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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking a number automatically to several sheets 3
Fill cell colour based on input in another cell 2
Min+Max from other Tabs 4
Linking a Specific Word to a Specific Number 1
Linking a Specific Word to a Specific Number 2
Linking a Specific Word to a Specific Number 1
Linking to other worksheets 3
Linking value of cell on one worksheet to a column on another work 1

Back
Top