You will need to:
1) Decide some criteria for choosing which sheets to evaluate or not. Perhaps any sheet that DOESN'T start with "RAN" and isn't the summary sheet.
2) You'll need to adjust your lastrow/nextrow evaluations to the correct column:
3) You don't need the find column stuff since all your sheets seem to be the same layout. (remove ColARR and Clm and ColFIND dims and code referring to it)
4) You will need to actually apply an autofilter to each sheet based on the criteria you've entered. I use a lot of autofilters in my macros.
You can get sample code usually by just turning on the macro recorder and letting it record you doing your autofilter, then edit the code down into your macro in the transfer section.
5) To use autofilters, you will have to delete those blank yellow rows on row2 of all your sheets. Blank rows indicate the end of the data set so the autofilter would never see the data below the blank row.
Here's the tweaked code, you'll have to fix your sheets as noted so that it will work properly. There also wasn't enough sample data in there for me to even wonder if it's going to work as expected, as there was no sample "results" either. Give it a go...
Bookmarks