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

J

JVorch

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
 
D

Dave F

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?
 
J

JVorch

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
 
Top