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

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