Pivot Table help

Y

Yossy

Please I need help with Pivot table. I have a Pivot Table that Have multiple
Rows of data but each row is collapsed and there are multiple rows of data
under each row.

I want to run a macro that will pick Each Row and their corresponding
collapsed data to another sheets.

Pivot table Example in Sheet 1: When collapsed
Cell A B C
1 + Hour Today's Date Only Hour
2 +Time Today's Time Only Time
3 +Day Hourly Day Monthly Time

When Expanded in sheet 1:
Cell A B C
1 -Hour Today's Date Only Hour
10/14/0994 12.00pm
01/10/9001 2.00pm
2 -Time Today's Time Only Time
07/11/2005 3.00pm
11/10/2000 8.00pm
3 -Day Hourly Day Monthly Time
------- 2.00pm
8/10/2009 13pm of day

Final Output
Sheet 2
Hour Today's Date Only Hour
10/14/0994 12.00pm
01/10/9001 2.00pm

Sheet 3
Time Today's Time Only Time
07/11/2005 3.00pm
11/10/2000 8.00pm

Sheet 4
Day Hourly Day Monthly Time
------- 2.00pm
8/10/2009 13pm of day
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add Hours by Looping through Data Q 27
Using VBA to create charts 1
Playing back a Pivot Table macros 2
Pivot Tables - Filtering on summed values 0
Find then highlight in yellow 6
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Need help with please.. 2
Payment Coupons 0

Top