On Apr 5, 3:34*pm, Anthony Blackburn
wrote:
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.