Attached is a sheet in which the tab Pivot Table is created from data in the tab Date. I need a macro/vgb that would do the following:
1) Copy the data for each customer in the Pivot Table(along with header)
2) Create a new tab and name it specifically for each customer
3) Auto-size the columns in the new tab
I have manually created the 4 tabs that I need created automatically. The real application will have dozens of customers with dozens of part #'s. Some of the the customers names are too long & have characters in them that TAB names do not allow. The code will have to adjust for that.
Thank you in advance for your help.
Bookmarks