Howdy All,
In my attached sample file I have a pivot table with specific column widths but whose length and individual row height will fluctuate depending on the data set. In column F of the pivot tab, but outside of the pivot table, text will be manually added to various rows which, at times, causes the text to wrap and thus the row height adjusts accordingly. Once finished I manually copy half of the table to Leasing1 and the other half to Leasing2 (not part of macro), the split being determined by total row height.
Upon completion, this file is made public. At this point other users make adjustments to the cells in column F of the pivot tab, which creates a difference in total row height between the two Leasing tabs.
I'm looking for a macro that, once run, will:
1. look at the total height of the pivot table
2. divide that height by 2 (rounded to the nearest row)
3. copy the first half of the roughly evenly split pivot table to Leasing1
4. copy the remaining half of the pivot table to Leasing2
Manually copying and formatting the two Leasing tabs after all adjustments have been made to pivot tab column F is not an option, unfortunately.
This has had me stumped for a week. Many thanks in advance.
Bjordion
Bookmarks