Filter_VBA

[alecmat]

Evening,

I am trying to learn the VBA for creating filters. For example on the attached spreasheet, column Q has various 4 digit #'s, but I would like to know a macro that filters only 5601, 5801, 6001, 6201, 6301, 7701, 8801, 9201, 9501. I have utilized the record macro to get the below code:

But the issue is the range. The range of data may change from week to week, it will not always end at row 327. How would i adjust the code so it will look at all the data that is in column Q (which again, could change from week to week) yet still filter only what I want?

Please Login or Register  to view this content.

Thanks so much for the guidance!
Alec

[:) Sixthsense :)]

Some thing like this..........

Please Login or Register  to view this content.

[alecmat]

Yes, that indeed worked. Thanks so much for the assistance.