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!
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!