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

LearnerExcel · #1 03-09-2018, 04:57 AM

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.

NoSparks · #2 03-10-2018, 01:36 PM

Use variables instead of hard coding.

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