Hello, could you help me with a VBA code to prevent overlap? I've got three pivot tables stacked with the same source. First table will show 100 census community. Second table will show 90 percent to 99 percent. Third table to show all communities below 90 percent. I'd like the rows to automatically add and delete itself where there is only one row separating each of the pivot tables. At the moment, it gives an error message when adding new lines to the Table sheet. I hope all this makes sense.
Thanks!

Attached Files

Occupany Olympics - Macro - 10-8-18.xlsm (33.2 KB, 8 views)

You guys likely have a ton of things to work on but if you could help me with this small issue, it would be greatly appreciated. Thank you!