I am trying to use the code listed in post #11 at http://www.excelforum.com/excel-prog...refreshes.html to achieve what i have listed below, I am not having any luck.
I have data in a workbook with a pivot table tab that is connected to a data file via a query. This pivot table refreshes everytime i open the file. The only thing that changes is the data, the cell locations are fixed. I have created a second tab on this workbook which links to the pivot table and takes the figure totals and puts them in this second tab in a nice uncluttered display. What I would like to do is to have this second tab archive all of the data that is currently purged every time I open and refresh the workbook. to say it another way, I would like the data in B2:B150 which is pulling from 'pivottable'!AA28 - "pivottable"!AA176 to be moved over to C2:C150 when i open and refresh the workbook. Then everytime I open the workbook after that they data would continue to move right with the most current data being in column B, the second to most current data in column C, and so on.
Bookmarks