Filtering For 2 Entries

[JonesZoid]

I have a macro that opens up a couple of other workbooks and extracts certain data. What i require is an addition to filter for 2 Entries in a column.

I need to pick out "4-YO" & anything beginning with a Y.

Please Help

JonesZoid

[VBA Noob]

Try something like

Assumes data to filter is Col A. Add workbook name and sheet name if a different workbook

Please Login or Register  to view this content.

VBA Noob

[JonesZoid]

Looks like it will work - looks like i've missed out some code elsewhere at the mo....

Cheers

JonesZoid