Hi all,
I need help with taking data from a pivot table and generating a data table, I think a macro or VBA would be the best bet.
For example:
This is my Pivot table (sheet 2):
Row labels Sum of invoices Sum of invoices not valid Sum of valid invoices Sum not submitted Sum of total submitted Sum of % submitted
Blue 10 1 9 3 6 67%
Pink 1 0 1 0 1 100%
White 5 0 5 2 3 60%
Grand total 16 1 15 5 10 67%
In another sheet (sheet 1) I want it to create a table like this. the table should label all rows and columns and populate the correct data from that pivot table
# of invoices # Valid # submitted % submitted
White
Blue
Pink
Totals
Can someone help me with this? That would be great, thanks
I need help with taking data from a pivot table and generating a data table, I think a macro or VBA would be the best bet.
For example:
This is my Pivot table (sheet 2):
Row labels Sum of invoices Sum of invoices not valid Sum of valid invoices Sum not submitted Sum of total submitted Sum of % submitted
Blue 10 1 9 3 6 67%
Pink 1 0 1 0 1 100%
White 5 0 5 2 3 60%
Grand total 16 1 15 5 10 67%
In another sheet (sheet 1) I want it to create a table like this. the table should label all rows and columns and populate the correct data from that pivot table
# of invoices # Valid # submitted % submitted
White
Blue
Pink
Totals
Can someone help me with this? That would be great, thanks