Advanced Filtering of Large Spreadsheets

[cjt]

Hey everyone,

I have a large spreadsheet of transactions that I need to filter by four digit numbers in one of the columns. I need the data to be filtered using a large number of these four digit department numbers at once. I am trying to figure out how to best do this , I have looked into putting an array of the numbers as criteria into an auto filter in VBA but have been unsuccessful so far. Any help?

Thanks a lot for the help!

[Aflatoon]

What have you tried? (how many is a large number?)