#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Please help
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!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Not sure how to display this data in a pivot table | makaveli80 | Excel | 8 | 04-04-2018 11:24 AM |
Data not showing in Pivot Table | MichelPierre | Excel | 2 | 01-26-2016 10:51 AM |
Prevent access to raw data in a pivot table? | Chancy | Excel | 3 | 02-03-2015 11:33 AM |
Pivot Table Duplicate Data | cnw | Excel | 0 | 08-31-2012 08:24 AM |
pivot table source data | hannu | Excel | 0 | 07-03-2010 04:54 AM |