Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
terrible problem
I would like to know if this is possible: I have two workbooks.. one from this fiscal year and one from last each has 5 reports each of them with 12 months. Currently every month, I pull up last years report and add in the month I am in from last year.. ex: we are in dec of FY 06, so I would go to dec FY 05 and add up sept, oct, nov and dec to get my total. I need to just add a month from the previous year each month. Is there a formula that could do that each month that would just do it when I opened the workbook, if the month had changed?? -- imjustme ------------------------------------------------------------------------ imjustme's Profile: http://www.excelforum.com/member.php...o&userid=26854 View this thread: http://www.excelforum.com/showthread...hreadid=497401 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
terrible problem
Hi
Supposing your sheets had month names starting in B1 and extending through M1, and had Row labels in A2 downward. With A1 being blank, enter in A1 the number of months required to be summed, then the formula would be =SUM(Sheet1!$B2:OFFSET(Sheet1!$B2,0,0,1,A1)) Copy down for other rows. Change Sheet name for other years. -- Regards Roger Govier imjustme wrote: I would like to know if this is possible: I have two workbooks.. one from this fiscal year and one from last each has 5 reports each of them with 12 months. Currently every month, I pull up last years report and add in the month I am in from last year.. ex: we are in dec of FY 06, so I would go to dec FY 05 and add up sept, oct, nov and dec to get my total. I need to just add a month from the previous year each month. Is there a formula that could do that each month that would just do it when I opened the workbook, if the month had changed?? -- imjustme ------------------------------------------------------------------------ imjustme's Profile: http://www.excelforum.com/member.php...o&userid=26854 View this thread: http://www.excelforum.com/showthread...hreadid=497401 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
have some problem with database | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |