| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use a cell value as the ref argument in CELL"contents" form
C1 to U1 contain the formulae =CELL("contents",'Dec08'!B$41) where Dec08 is
the name of another sheet in the same workbook. (Of course, each cell betwen C1 and U1 refers to consecutive cells in row 41 in the Dec08 sheet.) I want to be able to add more month sheets (ex: Jan09) over time and create another line of cell references wihout having to manually set each new cell to the new month sheet. I've tried entering the sheet name in X1 and then refering to its contents in the Cell"contents" formulae, but the function always returns a error. I was unable t o use CONCATENATE or ADDRESS successfully. Help please. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert cell "contents" into a "comment" | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| how to use "if" logical argument to format/copy some pic. in cell | Excel Worksheet Functions | |||
| how to increase size of "name box" and "contents of cell " displa. | New Users to Excel | |||
| if one cell has "X" textin contents, then pull cell "Y"... | Excel Worksheet Functions | |||
Threaded Mode
