cross references to cells in a worksheet

[Lenny]

I use cross references (ref field) in my Word form templates to pull table
cell entries to other locations in the form or other pages.

I can't find anything in excel help pointing me in the right direction for
using cross references in an excel form that I am setting up.

Is there a similar method? I want to identify specific cells in sheet 1 and
have sheet 2 or 3 or 4 (however many additional sheets) pick up and reflect
the entries made in the sheet 1 cells...... assistance is really appreciated

Lenny

 

[joel]

Use a Named Range

worksheet menu

Insert - Name - Define

 

[JLatham]

Excel isn't a word processor and doesn't have things like cross referencing
as does Word.

If you want the value from a cell in one sheet to show up in a cell in
another sheet, you set up a formula to point back to the source data. Let's
say you are on Sheet2 and want to get the value from Sheet1, cell A19. In a
cell on Sheet2 you could manually enter the formula
=Sheet1!A19

But it's probably easier to let Excel do the work for you: Start by going
to the cell where you want your 'cross reference' and simply type in the =
symbol. Then choose the other sheet, and the other cell and hit the [Enter]
key. Excel will build the formula for you. This even works for setting up
links between workbooks.