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