Link cells between worksheets
 

I work for a State agency that is still using Excel 2003. Unfortunately,
most of the online help answers now refer to the 2007 version. Consequently,
instructions such as "click this, then click this" are unusable with previous
versions.

I have a table with various cells that need to retain the text that is
currently in the cell but that will link directly to another entire
worksheet, not to a specific cell. All sheets are within a single workbook.

Following the directions in the help section just performs a basic cut and
paste function. Any suggestions?

Link cells between worksheets
 

"Link to another entire worksheet" seems impractical to me.

Select the cells in Table.

Switch to other sheet and Paste SpecialPaste Link

Alternative............................

In Sheet2 enter =Sheet1!A1

Copy that across and down

To prevent zeros showing =IF(Sheet1!A1="",""Sheet1!A1)


Gord Dibben MS Excel MVP



On Wed, 4 Feb 2009 13:32:09 -0800, castateemployee
wrote:

I work for a State agency that is still using Excel 2003. Unfortunately,
most of the online help answers now refer to the 2007 version. Consequently,
instructions such as "click this, then click this" are unusable with previous
versions.

I have a table with various cells that need to retain the text that is
currently in the cell but that will link directly to another entire
worksheet, not to a specific cell. All sheets are within a single workbook.

Following the directions in the help section just performs a basic cut and
paste function. Any suggestions?

Link cells between worksheets
 

Would you explain this a little more? What do you want these cells to show?

castateemployee wrote:
I have a table with various cells that need to retain the text that is
currently in the cell but that will link directly to another entire
worksheet, not to a specific cell. All sheets are within a single workbook.