Filtering with multiple criteria
 

Hello,

I have a spreadsheet that contains multiple columns one of which is called
"SITE NO". I am looking to create a macro that would include multiiple site
numbers and have the records filtered just for the sites listed in the
macro. The site numbers are 5 digits long such as "17005, 18010, 34111,
12022, 15563" for example.

Thanks

Fred

Filtering with multiple criteria
 

The easiest way is probably to set up a helper column out of the way (say,
column AZ) and have a formula like
=OR(A2=17005,A2=18010,A2=34111,A2=12022,A2=15563)

and then record a quick macro of you filtering column AZ for "TRUE". This
way would also be easier to change which values you want to filter for.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"fgwiii" wrote:

Hello,

I have a spreadsheet that contains multiple columns one of which is called
"SITE NO". I am looking to create a macro that would include multiiple site
numbers and have the records filtered just for the sites listed in the
macro. The site numbers are 5 digits long such as "17005, 18010, 34111,
12022, 15563" for example.

Thanks

Fred