| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable sheet name in formula
Hello,
I dont know if this is possible, but I am trying to build a formula which contains the name of a sheet that will change every day. In fact, I would like a cell to contain the name of the sheet and then reference the content of that cell in my formula. Ex: sheet2.A3 would contain the text "Sheet2" my formula would look like = sheet2.A3!B4*C45........., where sheet2.A3!B4 would be cell B4 of sheet2. Thank you. Eric. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How To make a sheet reference Variable (eq: sum(sheet!D2:H2)) | Excel Discussion (Misc queries) | |||
| Variable sheet and Formula Sheet | Excel Discussion (Misc queries) | |||
| variable in a link where the variable is the name of the sheet | Excel Worksheet Functions | |||
| Variable Sheet Name in Formula | Excel Discussion (Misc queries) | |||
| Concatentate a formula with a variable sheet name. | Excel Programming | |||
![Eric[_20_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
