B
Bendinblues
The Data that I use for my pivot table keep changing each week. Weekly, I
copy and paste data from another excel spreadsheet into the workbook that
contains the pivot table. Each week I go in and rename the data range before
I refresh the data. Is there a way that I can perform the data refresh on the
new data without worrying whether this week the data contains 25 rows or 50
rows?
copy and paste data from another excel spreadsheet into the workbook that
contains the pivot table. Each week I go in and rename the data range before
I refresh the data. Is there a way that I can perform the data refresh on the
new data without worrying whether this week the data contains 25 rows or 50
rows?