Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-08-2018, 09:55 PM
baes10 baes10 is offline Pivot Table Preventing Overlap with new data Windows 7 64bit Pivot Table Preventing Overlap with new data Office 2007
Advanced Beginner
Pivot Table Preventing Overlap with new data
 
Join Date: Dec 2017
Posts: 33
baes10 is on a distinguished road
Default 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!
Attached Files
File Type: xlsm Occupany Olympics - Macro - 10-8-18.xlsm (33.2 KB, 8 views)
Reply With Quote
  #2  
Old 10-12-2018, 08:56 PM
baes10 baes10 is offline Pivot Table Preventing Overlap with new data Windows 7 64bit Pivot Table Preventing Overlap with new data Office 2007
Advanced Beginner
Pivot Table Preventing Overlap with new data
 
Join Date: Dec 2017
Posts: 33
baes10 is on a distinguished road
Default 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!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Preventing Overlap with new data Not sure how to display this data in a pivot table makaveli80 Excel 8 04-04-2018 11:24 AM
Pivot Table Preventing Overlap with new data Data not showing in Pivot Table MichelPierre Excel 2 01-26-2016 10:51 AM
Pivot Table Preventing Overlap with new data 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft