Hi there,
I have a pivot table on one worksheet, that is refreshed from a range of data on a second worksheet.
the data is refreshed using a query, so can contain different numbers of rows.
how can I code it to always refresh using the complete range from the data worksheet?
can anyone help?
Bookmarks