Syschronizing cells across worksheets
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. |
Syschronizing cells across worksheets
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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "CAVelarde" wrote: 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. |
All times are GMT +1. The time now is 12:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com