Macro to expand data from pivot table til EOF

Closed
DesertMoon20 Posts 7 Registration date Wednesday July 14, 2010 Status Member Last seen September 22, 2010 - Sep 15, 2010 at 02:00 PM
DesertMoon20 Posts 7 Registration date Wednesday July 14, 2010 Status Member Last seen September 22, 2010 - Sep 22, 2010 at 11:46 AM
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 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 19, 2010 at 08:18 AM
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 ?
DesertMoon20 Posts 7 Registration date Wednesday July 14, 2010 Status Member Last seen September 22, 2010
Sep 20, 2010 at 02:27 PM
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.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 20, 2010 at 04:46 PM
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
DesertMoon20 Posts 7 Registration date Wednesday July 14, 2010 Status Member Last seen September 22, 2010
Sep 22, 2010 at 11:46 AM
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