Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking worksheets
Hi,
I am working on a large workbook with many worksheets. The main worksheet that i have is where i enter all my info on. The heading for the columns are the months of the year. on the rows are the dollar amounts. The dollar amounts I have them flowing into my summary sheets. Right now I am having to change the summary formula every month because I need the new month to reflect. I need to know if there is a formula ormacro that I can put in that will change to current month I am working on automatically. Any help you can give me I would appreciate. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking worksheets
On Tue, 18 Mar 2008 08:49:00 -0700, Liz
wrote: I am working on a large workbook with many worksheets. The main worksheet that i have is where i enter all my info on. The heading for the columns are the months of the year. on the rows are the dollar amounts. The dollar amounts I have them flowing into my summary sheets. Right now I am having to change the summary formula every month because I need the new month to reflect. I need to know if there is a formula ormacro that I can put in that will change to current month I am working on automatically. I think OFFSET will work for what you want. Instead of linking to, for example, Input!D3, you should link like =OFFSET(Input!D3,0,Input!A1) Where Input!A1 contains the month you're in. This formula says: Start at D3, move zero rows away, and move a certain number of columns away as defined in A1. -- Dick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking worksheets | Excel Discussion (Misc queries) | |||
Linking two worksheets | Excel Worksheet Functions | |||
Linking Worksheets | Excel Programming | |||
Linking worksheets | Excel Discussion (Misc queries) | |||
linking worksheets | New Users to Excel |