Pivot Table Preventing Overlap with new data
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!
|