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
DesertMoon20 Posts 7 Registration date Wednesday July 14, 2010 Status Member Last seen September 22, 2010 - Sep 22, 2010 at 11:46 AM
Related:
- Macro to expand data from pivot table til EOF
- Transfer data from one excel worksheet to another automatically - Guide
- School time table software free download full version - Download - Organisation and teamwork
- Expand screen - Guide
- Tmobile data check - Guide
- Html table size to fit window - Guide
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
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
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
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
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
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
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
