Hi all,
I have a macro in the attached workbook which adds a new sheet with extracts from the Report sheet. Could you add a code please to the existing one so that it adds a pivot table in cell L2 similar to what I have on sheet 1. The number or rows will change every time a user updates the Report sheet, so the new sheet would need to show pivot for all rows in that sheet which will be different from sheet 1.
Thank you!
I asked the same question in the below forum
https://www.ozgrid.com/forum/forum/h...to-a-new-sheet
The idea of a forum is that you ask for help with an issue. It's not a case of telling us what you want and expecting someone else to do it for you.
Start by telling us what you have tried yourself that has not worked.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I tried, Ali G, and fell into abyss of parameters. That's why I am asking for help.
Last edited by rafuk73; 03-24-2018 at 09:15 AM.
Again, WHAT did you try? Helpers will be able to show you what needs to be changed if you provide the code you have tried to manipulate.
I attached my workbook and the code
Thread closed to avoid anyone wasting their time - the OP has found the solution elsewhere on the Internet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks