Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change sheet reference in formula?
XL2000
I have two workbooks, FOODCOST.XLS and INVENTORY TRACKING.XLS that are individually updated monthly via macros In INVENTORY TRACKING.XLS: Cell B42 currently contains the formula =SUMPRODUCT(('C:\DATA\EXCEL\[FOODCOST.XLS]Nov'!$M$5:$M$34)*('C:\DATA\EXCEL \[FOODCOST.XLS]Nov'!$K$5:$K$34="Sysco")) Cell G42 currently contains the formula ='C:\DATA\EXCEL\[FOODCOST.XLS]Nov'!$E$36 FOODCOST.XLS is updated monthly to add a sheet with the abbreviated name for the next month. Is there some code I can add to an existing routine in INVENTORY TRACKING.XLS that would automatically adjust these formulas to refer to the latest month's sheet in FOODCOST.XLS? Or could I change something in the formulas themselves that will tell them to look at the range(s) in the latest sheet in FOODCOST.XLS? -- David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graph data series formulas: How to global-change all sheet reference to formula | Excel Discussion (Misc queries) | |||
How to change a reference when the sheet change the folder? | Excel Worksheet Functions | |||
Is it possible to change a Sheet reference in a formula? | Excel Discussion (Misc queries) | |||
Change the work sheet name in a formula by using cell reference | Excel Worksheet Functions | |||
Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions |