worksheet cell display

[Anthony Blackburn]

I want the data in a cell on one worksheet to show in a cell on another
worksheet in the same workbook. How do I do this?

Thanks

 

[OssieMac]

In the cell where you want the data to show, enter = and while still in the
edit mode, change worksheets and click the cell that you want it to match and
then press Enter and it will insert the required link for you.

 

[Ivyleaf]

I want the data in a cell on one worksheet to show in a cell on another
worksheet in the same workbook. How do I do this?

Thanks

Hi Anthony,

If one of the data cells will just be a 'visual display' of the other,
then in the display cell, just type '=' then switch to the other
sheet, select the cell and hit 'enter'
If you want either cell to accept data entry, then you will have to
run a Worksheet_Change event macro that looks at which cell you have
changed; if you changed the 'hot' cell then the code can copy that
value to the other sheet. You will also need the opposite version of
the macro on the other sheet as well.

Cheers,
Ivan.