Syschronizing cells across worksheets

C

CAVelarde

I have searched all the help files and canot find any guidance to set cells
in one worksheet to automatically sync with predetermined cells in another
worksheet.
Basically I want to be able to update the names of people in one worksheet
and have the names automatically updated in the rest of the worksheets to
more easily track project responsibilities.
 
L

Luke M

option a)
One sheet is the 'input' sheet. All other sheets use formulas to reference
the input sheet and thus will show whatever value is inputted.

option b)
Select multiple sheets (use Ctrl and/or Shift). Make an edit in a cell. All
selected sheet will reflect this change.
 

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

Syncing between source worksheet and dependent worksheets 0
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
How to update a value from a linked worksheet back to the master worksheet? 0
index-match function across different worksheets 0
Duplicating a cell from one worksheet to another worksheet 1
How to update data from linked worksheet back to a master worksheet? 0
CELL CONTENTS WRITE TO TAB NAME 0

Top