How can I link to the worksheet directly before the one containing mypivot tables?

R

robert

Hi,

I have many sheets of data from different tests. For each test I have
made a sheet of pivot tables with summaries for this test. The summary
sheet can be copied from test to test, but I need to go into each
pivot table to change the reference so it points to the correct data
sheet. Is there a way to point to the datasheet directly before the
summary sheet based on the position of the worksheets in the workbook?
Or are there any other good ways of updating all the pivot tables at
once?

Best regards

Robert Ruud
Oslo, Norway
 
Top