| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedding the value of a cell in a formula
I would like to have the contents of a cell be part of a formula. For example:
In one cell I have the year: 2009 In the other a formula references another workbook: =C:/.../Ad Sales 2009!A1 I would like to be able to change the first cell to year 2010 and have the formula automatically change with it to =C:/.../Ad Sales 2010!A1 Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedding in a cell. | Excel Discussion (Misc queries) | |||
| Embedding a macro within a formula | Excel Worksheet Functions | |||
| Embedding Word table in Excel cell | New Users to Excel | |||
| Embedding a reference in a cell with normal text. | Excel Worksheet Functions | |||
| Embedding file name in a Cell | Links and Linking in Excel | |||
Threaded Mode
