Hi Guys,
A beginner at using macros / advanced stuff in excel.
I need help with cleaning up a spreadsheet for work.
Issue. I need to get data from a pivot table into a new tab. The data from the pivot table is pasted into one tab and then the pivot table is refreshed in another. Once the pivot table has been made, I have another tab that needs to take the data from the pivot table and copy down until the grand total is hit. Right now it is just using ='Pivot table'!A5 and is dragged down about 200 cells to get the information. This makes more work, having to delete #N/A's once the amount of rows in the pivot table has been reached or drag the formula furhter down if the pivot table has more than 200 rows.
I would like to have a function or macro setup so it would count the number of rows in the pivot table and only pull that actual information and stop at grand total if possible.
If this dosen't make sense I can send you the spreadsheet in email.
Thanks for the help!
A beginner at using macros / advanced stuff in excel.
I need help with cleaning up a spreadsheet for work.
Issue. I need to get data from a pivot table into a new tab. The data from the pivot table is pasted into one tab and then the pivot table is refreshed in another. Once the pivot table has been made, I have another tab that needs to take the data from the pivot table and copy down until the grand total is hit. Right now it is just using ='Pivot table'!A5 and is dragged down about 200 cells to get the information. This makes more work, having to delete #N/A's once the amount of rows in the pivot table has been reached or drag the formula furhter down if the pivot table has more than 200 rows.
I would like to have a function or macro setup so it would count the number of rows in the pivot table and only pull that actual information and stop at grand total if possible.
If this dosen't make sense I can send you the spreadsheet in email.
Thanks for the help!
