Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Updating links monthly...
OK, so I've searched the FAQ's and couldn't find an answer to my problem...please help if you can! I have a spreadsheet that contains monthly (JAN-DEC) values for expenses from our multiple regional offices, with a monthly total for the account. There is also a summary sheet that links to this main spreadsheet. The summary sheet just shows the total for the current month vs. the total for the previous month per region. Every month I must update the main spreadsheet with totals, then update the summary spreadsheet to show the new current month (Example, last month, the spreadsheet showed August vs. July, this months spreadsheet shows September vs. August, next months will show October vs. September, etc). Which leads to my question: Is there a function I can use so I can just enter, say, "September 2005" somewhere on the summary sheet and then the summary sheet will know to grab the September totals from the main spreadsheet?? Thanks in advance, Jeff -- need help ------------------------------------------------------------------------ need help's Profile: http://www.excelforum.com/member.php...o&userid=28092 View this thread: http://www.excelforum.com/showthread...hreadid=475953 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 links are not updating between workbooks | Excel Worksheet Functions | |||
External Links not updating | Excel Discussion (Misc queries) | |||
?? Links Not Updating ?? | Excel Discussion (Misc queries) | |||
Links updating? | Excel Discussion (Misc queries) | |||
Updating Automatic links doesn't work with arrays | Excel Discussion (Misc queries) |