Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #46  
Old 01-06-2016, 02:19 PM
inreality01 inreality01 is offline Complex calculation from multiple sheets to master sheet Windows 7 64bit Complex calculation from multiple sheets to master sheet Office 2013
Advanced Beginner
Complex calculation from multiple sheets to master sheet
 
Join Date: Dec 2015
Posts: 34
inreality01 is on a distinguished road
Default

Guess what?



I figured out how to get the Pivot Tables to auto-refresh by adding a couple lines of code..... right-click on the tab and added the code and now it refreshes! nice.

Okay, so one last time I would like to thank you for all your help and for educating me.

I am about to release the new spreadsheet on my co-worker and hopefully it works well for him.

Thanks so much!
Reply With Quote
  #47  
Old 01-06-2016, 02:22 PM
inreality01 inreality01 is offline Complex calculation from multiple sheets to master sheet Windows 7 64bit Complex calculation from multiple sheets to master sheet Office 2013
Advanced Beginner
Complex calculation from multiple sheets to master sheet
 
Join Date: Dec 2015
Posts: 34
inreality01 is on a distinguished road
Default

You know what, there is one last......... one final question that maybe you can help with.

The last thing I am looking to do is make the Pivot Table display every other row as an alternate color so it is easier to follow the data across.

I'm working on this now, I'm guessing it can't be too hard.
Reply With Quote
  #48  
Old 01-06-2016, 02:29 PM
inreality01 inreality01 is offline Complex calculation from multiple sheets to master sheet Windows 7 64bit Complex calculation from multiple sheets to master sheet Office 2013
Advanced Beginner
Complex calculation from multiple sheets to master sheet
 
Join Date: Dec 2015
Posts: 34
inreality01 is on a distinguished road
Default

Disregard, I got it all.

Thanks again for everything. I owe you.
Reply With Quote
  #49  
Old 01-06-2016, 03:08 PM
gebobs gebobs is offline Complex calculation from multiple sheets to master sheet Windows 7 64bit Complex calculation from multiple sheets to master sheet Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by inreality01 View Post
I'm also curious as to how you have the Investigator drop down selection on Pivot 2 as it seems to be a different setup than Pivot 1.

If you can push me in the right direction that would be great, I'm not expecting you to keep doing all the work.
See my post above.
Quote:
* Pivot2 is the same except Investigator is in report Filter rather than Row Labels.
Quote:
Originally Posted by inreality01 View Post
Damn...... That was easy! Why doesn't the Wizard tell me I can do this????

I'm a Pivot Master. HA HA HA
I assume you have it now. See? I told ya. Pivot Tables are a breeze and quite powerful.

Next step...charting!
Reply With Quote
  #50  
Old 01-06-2016, 03:09 PM
gebobs gebobs is offline Complex calculation from multiple sheets to master sheet Windows 7 64bit Complex calculation from multiple sheets to master sheet Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by inreality01 View Post
Disregard, I got it all.

Thanks again for everything. I owe you.
Not even a problem. Good clean fun.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Complex calculation from multiple sheets to master sheet Excel, transfer data from Master Sheet to sub sheets, using key word from column anvqui Excel Programming 9 06-16-2015 01:35 PM
Need help in automating data from multiple sheets into a single sheet veedee Excel Programming 8 06-12-2014 10:04 PM
Complex calculation from multiple sheets to master sheet Need help in automating data from multiple sheets into a single sheet veedee Excel 1 06-11-2014 04:01 AM
Combine Data From 2 Sheets into a new sheet bremen22 Excel 1 09-11-2013 12:59 PM
Complex calculation from multiple sheets to master sheet How do I merge data from one sheet in a workbook out into multiple sheets nolesca Excel 4 06-07-2010 08:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:41 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