Filtering Based in a cell value

[Steve Wright]

I have a list which I want to filter based on the value of a cell that is
not in that list.

Any ideas?

eg

List of values to be filtered in Column X

aaa
aaa
bbb
bbb
ccc
ddd
eee
fff
ggg


The value I want to filter by in A1 derived from Data validation list on
separate sheet

aaa


I want to filter out all the values that are not aaa


TIA
Steve

 

[Dave Peterson]

How about a helper column with a formula like:

=a2=sheet2!$a$1
(dragged down)

Then you can filter on True/False for that column.

 

[Mike]

Maybe a VBA macro using this line would work for you:

Range("X1").AutoFilter Field:=1, Criteria1:="<>" & Range
("A1")