Thread: One formula required to copy information from YTD spreadsheet onto individual monthly spreadsheets.
View Single Post
 
Old 10-15-2015, 08:00 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit 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