| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create link with sheet which is not inserted into workbook
I have a workbook containing Sheet 1, Sheet 2, Sheet3. If I write in cell A1
"March" of Sheet 1 and then put formula (=Sheet1!A1) in A1 of Sheet 2 it gives "March" in result. And if I put formula (=Sheet4!A1) then it result #REF! because Sheet 4 is not inserted. Is it possible ? If I insert Sheet 4 and write "March" in cell A1 automatically #REF! turns into "March" without changing formula of cell A1 of Sheet 2. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create link with sheet which is not inserted into workbook | Excel Discussion (Misc queries) | |||
| Link spread sheet to another workbook | Excel Discussion (Misc queries) | |||
| Link individual sheet to one sheet in another workbook | Excel Discussion (Misc queries) | |||
| how do i link from one sheet to another in the same workbook? | Excel Worksheet Functions | |||
| link cell from one sheet to another within the same workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
