worksheet cell display

  • Thread starter Thread starter Anthony Blackburn
  • Start date Start date
A

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
 
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.
 
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
Click to expand...

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.
 
Back
Top