Linking Numbers from one sheet to another

  • Thread starter Thread starter Kenneth
  • Start date Start date
K

Kenneth

I'm trying to figure out hoe I could link a number to
several other worksheets. I.E. if I typed the number 15.76
into B6, how could I get it to copy that number,
automatically, to eight other sheets in their B6 fields.
 
Kenneth,

Select the sheets to get the B6 value from the source sheet (Use Shift
and/or Ctrl as necessary).
Select B6 ( on any of the selected sheets).
Type =
Select the source sheet, then the B6 cell.
Press Ctrl-Enter

Only B6 in the source sheet should be changed. If a user types a value into
one of the other B6 cells, it will replace the link to the source sheet.
 
Back
Top