Link cells between worksheets

[castateemployee]

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?

 

[Gord Dibben]

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

Select the cells in Table.

Switch to other sheet and Paste Special>Paste 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

 

[smartin]

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