Hello
I have a worksheet with 2 exactly identically structured tables placed right below one another in the same worksheet for report.
Both these tables are pivot tables and are dynamic i.e. based on the filter selection criteria the number of rows changes in each table. I need 2 blank rows between the two tables as part of the report format.
I am wondering if I can automatically get the bottom table to move up or down within the sheet based where the last row of top table is. I need to maintain a constant gap of 2 rows between the tables. (i.e. the last row of top table and the header row of bottom table)
Can any please help ??
TIA
I have a worksheet with 2 exactly identically structured tables placed right below one another in the same worksheet for report.
Both these tables are pivot tables and are dynamic i.e. based on the filter selection criteria the number of rows changes in each table. I need 2 blank rows between the two tables as part of the report format.
I am wondering if I can automatically get the bottom table to move up or down within the sheet based where the last row of top table is. I need to maintain a constant gap of 2 rows between the tables. (i.e. the last row of top table and the header row of bottom table)
Can any please help ??
TIA