Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference a cell for a formula
Is there a way to have a formula that references a cell as part of the
formula. For example, I have the following formula in many cells... 'G:\B\BUDGET\2008 Variance\Jul08\[Jul Variances.xls]010 New York'! $L32/1000. Is there a way to have the word "Jul" in a cell (A2) and have +A2 as part of the formula. This is so that each month, I just change A2 to the next month and all of my formulas change easily. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
Using a cell reference within a cell reference in a formula | Excel Worksheet Functions | |||
How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |