PDA

View Full Version : Advanced Filtering of Large Spreadsheets



cjt
02-03-2015, 11:52 AM
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
02-04-2015, 04:43 AM
What have you tried? (how many is a large number?)