| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing sheet reference to cell reference
On one sheet I have the formula ='TeeJay'!$L$40 where TeeJay is the name of a
different sheet to the one I'm working on but in the same workbook. Is it possible to change the formula so that it refers to a cell on the current sheet that has a reference to the other sheet? If I had ='TeeJay'!A1 (where A1 has the name of the sheet) in cell K1 on the current sheet, would it be possible to get a formula that works =K1!$L$40 If I try this at the minute, I get a dialog box to update values. How should I be writing this formula? I'm using Excel 2000 and would prefer not to use VBA (some of the computers this will have to be viewed on have macros disabled). Many thanks for any help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| stop insert from changing cell reference | Excel Worksheet Functions | |||
| Problem with formulas changing cell reference | Excel Discussion (Misc queries) | |||
| A cell reference in a formula changing | Excel Worksheet Functions | |||
| HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE | Excel Discussion (Misc queries) | |||
Threaded Mode
