Hi All,
I have a tab "Rep List" that has a list of items I'd like to loop through (the example only has three, but it would have hundreds).
The Summary tab $A$1 would be changed to the Rep List item, that same item would be the autofilter on Column B for the Monthly ARR through One Time Fee Annual tabs.
Then the Summary through One Time Fee Annual tabs would be selected, copied to new file, and named to the Rep List item (what is autofiltered).
Then it would move to the next item on the Rep List tab and loop.
I can't figure out how to a) use the autofilter on multiple sheets and b) create a loop doing so.
I've attached a sample file with dummy data.
I'd appreciate any advice.
Thanks all!
Clroth
Bookmarks