Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #27  
Old 01-06-2016, 12:31 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

I see how the drop downs are working and how to adjust the rows on the Data page to include or exclude what is in the drop down. Very nice, thanks.

I'm trying to adjust the Pivot Table now as they are not updating when I refresh. It looks like some old references are in the Pivot Table. I'm seeing if I can figure out how to change this. It's showing the investigator initials but I replaced all of them with their real names now. The Log sheet drop downs updates but not the Pivot.
Reply With Quote
 



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 08:35 AM.


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