![]() |
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 |
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 |
All times are GMT +1. The time now is 12:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com