Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Problem in pasting copied data to Coda Financial Acco | Excel Discussion (Misc queries) | |||
transfer data cd 2003 excel to c: 2002 xp | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Dynamically create worksheets in Excel based off existing data? | Excel Discussion (Misc queries) | |||
How do I sort data into 2 worksheets in excel vba? | Excel Worksheet Functions |