rfmartinez
New Member
- Joined
- Sep 29, 2010
- Messages
- 3
My scenario is this...
I have about 200 employees. Each working in different departments of the company.
In Excel 2007, I have 9 sheets in one workbook. Each sheet can vary from 6 to 40 rows (one row per employee with each row consisting of about 9 columns of contact information). The numbers of rows changes per month depending on gain or loss of employees.
Rather than repeatedly copy and pasteing each update from the department sheets to the main sheet, how do I make it so that Excel automatically syncs each sheet to the main sheet?
All help is greatly appreciated.
I have about 200 employees. Each working in different departments of the company.
In Excel 2007, I have 9 sheets in one workbook. Each sheet can vary from 6 to 40 rows (one row per employee with each row consisting of about 9 columns of contact information). The numbers of rows changes per month depending on gain or loss of employees.
Rather than repeatedly copy and pasteing each update from the department sheets to the main sheet, how do I make it so that Excel automatically syncs each sheet to the main sheet?
All help is greatly appreciated.
