How to Auto Filter data based on Cell E1 text as Criteria?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to Auto Filter data based on Cell E1 text as Criteria?

FAQ

Thread Tools

Display Modes

03-09-2018, 04:57 AM

LearnerExcel LearnerExcel is offline

Windows 7 32bit How to Auto Filter data based on Cell E1 text as Criteria?

Office 2013

Advanced Beginner

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

How to Auto Filter data based on Cell E1 text as Criteria?

How to Auto Filter data based on Cell E1 text as Criteria?

Sub FilterData()
With Sheet1
.AutoFilterMode = False
.Range("B8:O8").AutoFilter
.Range("B8:O8").AutoFilter Field:=6, Criteria1:="Books"
End With

End Sub

This code is retrieving data that contain the text "Books" in Column 6.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to modify code for Auto filter based on two criteria ...	LearnerExcel	Excel Programming	13	02-14-2018 08:20 PM
Auto enter data based on formula in another cell?	RonLEngle	Excel	5	06-30-2017 11:44 AM
Filter Mail Merge based on a list of filter criteria	AusSteelMan	Mail Merge	2	05-09-2016 03:35 PM
Auto Filter base on a value in another cell in same worksheet	z941714	Excel	1	08-14-2015 07:41 AM
cell text to auto populate if criteria matches	Jackie	Excel	2	02-06-2015 07:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:31 PM.