ExcelBanter - Refreshing Pivot Tables QUery

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Refreshing Pivot Tables QUery (https://www.excelbanter.com/excel-programming/284292-refreshing-pivot-tables-query.html)

Ron McCormick[_2_]

Refreshing Pivot Tables QUery

Does anyone know of a way of controlling
PivotTables 'refresh data' procedure so that where there
are two tables on one sheet the second table will
automatically be moved down (or up) when data in the first
table is refreshed?

TIA
Ron

Tom Ogilvy

Refreshing Pivot Tables QUery

Pivot Tables don't work that way. You would have to have enough space to
start with or put them side by side.

--
Regards,
Tom Ogilvy

"Ron McCormick" wrote in message
...
Does anyone know of a way of controlling
PivotTables 'refresh data' procedure so that where there
are two tables on one sheet the second table will
automatically be moved down (or up) when data in the first
table is refreshed?

TIA
Ron

All times are GMT +1. The time now is 05:19 AM.