Hi all,
I know this is a fairly common question, but I have not been able to figure out how to apply to my situation.
I have a workbook (see attached) with a filter already in it in cell B1. For each of the filter criteria, I want to copy and paste each sheet into a new workbook. Is this possible?
Thanks for any help you can offer with this.
What would be the new workbooks' names?
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
It would be ideal for the new workbooks to be named based on the filter -- whatever the filter value is, is the workbook name. This is not critical, however.Originally Posted by p24leclerc
As your Territory tab uses a pivot table, we'll have to copy only values for each filter value into the new sheets.
Is that OK?
see attached file for working example.
here is the macro:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks