Macro to expand data from pivot table til EOF

Closed
Posts
7
Registration date
Wednesday July 14, 2010
Status
Member
Last seen
September 22, 2010
-
Posts
7
Registration date
Wednesday July 14, 2010
Status
Member
Last seen
September 22, 2010
-
I need help on expanding the data from my pivot table... My pivot table has only two columns, let's say column A & B with around 50 rows... Normally, I would double-click column B1 (Summary Sheet) and will create a new sheet showing the details, and go back to the summary sheet B2 and so on until I reach the last row which is 0.

Appreciate your help on this one...

Thanks,
DM

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Pivot tables are summary view of data. if you plan to click on each row of pivot table wont you get your original sheet back ?
Posts
7
Registration date
Wednesday July 14, 2010
Status
Member
Last seen
September 22, 2010

Yes, what I was working is the result of the rows by clicking per row of the pivot table to re-create a new sheets, and work on the said result sheets.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample EXCEL file WITH sample data, on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee.
Note:
your data need not be to be real data but a good representative of how data looks like
Posts
7
Registration date
Wednesday July 14, 2010
Status
Member
Last seen
September 22, 2010

Hi rizvisa1,

As requested, I have attached the file in need of attention, please note that the drill down (create new worksheets) will start on B5 onwards, and needed a macro until it reaches the last cell.

http://spreadsheets.google.com/...

Again, thanking you for spending your time to help.

Regards,
DM