Using macros to save drilldowns with file names.

[sahmed95]

Good afternoon,

I am currently trying to create a macro where pivot table subtotals are taken and split by their client.
Once the file is opened, the columns have to be autofit, and the sheet has to be saved as the name of the client.

I've tried multiple methods without success.

Also, the potential client list is 45, and I have 30 regular ones; will I have to create it with all 45 in the pivot table in case they appear one week.

Any help would be appreciated.

Thank you.

So on the attached example I will have to click on the subtotals.
Initially B4
In this case there doesn't have to be any auto fit adjusting but in the actual data I will have to, then I want to save the file as the name of the client A.
Either from their own workbook or the summary work book.

The order of the clients might change and also some maynot be present next week, while some new ones maybe.

Is there a way to create a macro to handle this and the many variables at play.

Thank you.