| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link text between different worksheets within a workbook
I want to create a link between two worksheets in the same workbook to copy
text information from one cell on my first worksheet to a cell on the second worksheet. After all information has been entered on my first worksheet, I want to be able to sort the 2nd worksheet and have the copied information move with the remainder of the information. -- Thanks for all assistance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Link text between different worksheets within a workbook
=Sheet1!A1 anywhere on another sheet will display what is in A1 of Sheet1
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "ECS" wrote in message ... I want to create a link between two worksheets in the same workbook to copy text information from one cell on my first worksheet to a cell on the second worksheet. After all information has been entered on my first worksheet, I want to be able to sort the 2nd worksheet and have the copied information move with the remainder of the information. -- Thanks for all assistance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link Worksheets within a Workbook | Excel Discussion (Misc queries) | |||
| How do I link data between worksheets within a workbook? | Excel Discussion (Misc queries) | |||
| how do I link worksheets in the same workbook? | Excel Worksheet Functions | |||
| how do i link a list of items in a workbook to worksheets in the . | Excel Discussion (Misc queries) | |||
| Can't link cells in worksheets in same workbook | New Users to Excel | |||
Linear Mode
