Hi Guys,
I am trying to write a macro that will filter the data out of one workbook and paste it in another based on the criteria provided for in column A and C. The criteria for A is fixed say
"1" but the criteria for column C is going to be an array for 200 different items.
Also i want the macro to look through all the worksheets of a workbook as i have three worksheets with 65536 line items. and copy data to new workbook.
I have attached a dummy data sheet for reference.
So, my criteria for coulm A is "1" and array of criteria for colimn C is (" AA, BB, , DD, FF, GG, HH, JJ").
I want to macro to set Column A on "1" and then cycle through the criteria on Column C copy and pasting the data in to new work book, it will reset the filters each iteration. If there is error like it cant find any criteria in column C show message and continue to next criteria .
Any help will be highly apprecited.
Thanks.
Roop
Bookmarks