Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page One formula required to copy information from YTD spreadsheet onto individual monthly spreadsheets.
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 10-15-2015, 08:00 PM
macropod's Avatar
macropod macropod is offline One formula required to copy information from YTD spreadsheet onto individual monthly spreadsheets. Windows 7 64bit One formula required to copy information from YTD spreadsheet onto individual monthly spreadsheets. Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
It's not clear which sheet(s) the data entry is done on. Assuming it's done on the 'Calculations' sheet, see attached. I had to modify that sheet's layout to give August the same layout as the other months, but the result is that the individual monthly data can be derived using a single formula on each of the monthly sheets, and the quarterly data can likewise be derived using a single formula for any month.
Attached Files
File Type: xlsx Sample Workbook.xlsx (43.1 KB, 13 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
One formula required to copy information from YTD spreadsheet onto individual monthly spreadsheets. formula for monthly sum paulys Excel 1 08-23-2014 09:44 AM
Copy Column setting to other spreadsheets in an excel workbook officeboy09 Excel 5 11-05-2013 01:49 AM
One formula required to copy information from YTD spreadsheet onto individual monthly spreadsheets. Monthly Growth Rate Formula meggenm Excel 2 04-22-2013 09:21 PM
One formula required to copy information from YTD spreadsheet onto individual monthly spreadsheets. Copy data from spreadsheets to a two, with the sum criterion marreco Excel Programming 1 05-15-2012 04:15 PM
Formula Help Required OTPM Excel 6 08-31-2011 02:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:01 AM.

Contact Us - Privacy Statement - Top

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