Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add cells in several worksheets | Excel Worksheet Functions | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
sum of different cells in different worksheets??? | Excel Worksheet Functions | |||
sum of different cells in different worksheets??? | Excel Worksheet Functions | |||
sum of different cells in different worksheets??? | Excel Worksheet Functions |