Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
how do i link one sheet to another sheets cell of the same workbook? I'M
TRYING TO DO '=' AND THE NSELECTING THE ANOTHER SHEET TO LINK TO THE CELL OF ANOTHER WORKBOOK BUT ITS NOT HAPPENING. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
To link to A1 on Sheet2, from A1 on Sheet1, in cell A1 on Sheet1 type equal sign, then select A1 on Sheet2 an hit Enter. The formula in A1 on Sheet1 should read =Sheet2!A1 Regards, Per "MANDAR" skrev i meddelelsen ... how do i link one sheet to another sheets cell of the same workbook? I'M TRYING TO DO '=' AND THE NSELECTING THE ANOTHER SHEET TO LINK TO THE CELL OF ANOTHER WORKBOOK BUT ITS NOT HAPPENING. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Chart-data references link another worksheet in same workboo | Excel Discussion (Misc queries) | |||
how to link data from one source sheet to multiple sheets | Excel Worksheet Functions | |||
Can columns be hidden accross multiple sheets in an Excel workboo | Excel Worksheet Functions | |||
link between sheets get messed when master sheet is sorted | Excel Worksheet Functions | |||
How do I copy a worksheet without the link to the original workboo | Excel Discussion (Misc queries) |