In Excel 2002, how do I synchronize data with other worksheets?
 

I have a payroll spreadsheet with multiple individual spreadsheets feeding to
a master control. What is the easiest way in Excel 2002 to synchronize
changes to our employee roster on each spreadsheet without relying relaying
on having formulas in each spreadsheet referencing the master? Thank you

In Excel 2002, how do I synchronize data with other worksheets?
 

It's not clear what you're trying to do. How do you propose to update sheets
with information in other sheets without establishing formula based links
between them?
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"JVorch" wrote:

I have a payroll spreadsheet with multiple individual spreadsheets feeding to
a master control. What is the easiest way in Excel 2002 to synchronize
changes to our employee roster on each spreadsheet without relying relaying
on having formulas in each spreadsheet referencing the master? Thank you

In Excel 2002, how do I synchronize data with other worksheets
 

I suppose the biggest question is, what are you trying to accomplish?

"Dave F" wrote:

It's not clear what you're trying to do. How do you propose to update sheets
with information in other sheets without establishing formula based links
between them?
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"JVorch" wrote:

I have a payroll spreadsheet with multiple individual spreadsheets feeding to
a master control. What is the easiest way in Excel 2002 to synchronize
changes to our employee roster on each spreadsheet without relying relaying
on having formulas in each spreadsheet referencing the master? Thank you

In Excel 2002, how do I synchronize data with other worksheets?
 

Thanks for the critique. I have a master control listing of names of
employees on Sheet 1 (say), and an individual group of worksheets (sheet 2,
etc) that calculate overtime, vacation pay, etc. I want to use a VLOOKUP
formula to bring the information back from the individual worksheets to the
master control.

The issue is of course that the roster of employees is always changing, as
well as the name change of existing employees.

I do not want for my employees to have to remember to update the employee
roster on each individual worksheet for fear of omission.

Is there any anyway for the range "Employee roster" to automatically link to
each spreadsheet, most importantly for additions to the roster.

I hope this is stated appropriately. Thank you

"JVorch" wrote:

I have a payroll spreadsheet with multiple individual spreadsheets feeding to
a master control. What is the easiest way in Excel 2002 to synchronize
changes to our employee roster on each spreadsheet without relying relaying
on having formulas in each spreadsheet referencing the master? Thank you