Hello all,
We have a routine task where we copy and paste the PnL information but with different customers to new worksheets.
- In the sheet "PnL", I have a Pivot table that I can filter different customers to see Revenue, Margin and Costs information.
- I have to select each customer/plant and manually copy and past to a new worksheet
I'm trying to get an excel macro that based on different Pivot table filtering, I'll generate new worksheet with the information I have in the "PnL" worksheet.
The list of sheet name will be "Filter list" and it contains 3 columns.
a) sheet name: created worksheet
b) customer name: e.g. nike
c) site: e.g. china
Please note that the Pivot table filter will depends on "b" and "c".
Is that possible? Thanks for your time.
We have a routine task where we copy and paste the PnL information but with different customers to new worksheets.
- In the sheet "PnL", I have a Pivot table that I can filter different customers to see Revenue, Margin and Costs information.
- I have to select each customer/plant and manually copy and past to a new worksheet
I'm trying to get an excel macro that based on different Pivot table filtering, I'll generate new worksheet with the information I have in the "PnL" worksheet.
The list of sheet name will be "Filter list" and it contains 3 columns.
a) sheet name: created worksheet
b) customer name: e.g. nike
c) site: e.g. china
Please note that the Pivot table filter will depends on "b" and "c".
Is that possible? Thanks for your time.
