Help with Looping Function or vlookup? Not sure what to use. Thanks!

jackjo05

New Member
Joined
Dec 19, 2013
Messages
8
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!
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Forum statistics

Threads
1,226,735
Messages
6,192,733
Members
453,752
Latest member
Austin2222

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top