MrStressed
Board Regular
- Joined
- Mar 25, 2002
- Messages
- 65
Afternoon All. I have a real nasty I need a solution for.
A spreadsheet has four sheets, one per region, each of these sheets lists employee id numbers, each employee has an id number for each sales area, some id numbers are the same in different sales areas. This is the sheet I need to populate from the following:
Spreadsheets for each area (twelve areas)listing the employee id number and the number of sales they have achieved for different product types.
How do I get the data from my 'area' sheets to my 'region' sheets ensuring that the correct data referenced to the employee id number goes to the correct 'region' sheet.
You help would be gratefully appreciated
A spreadsheet has four sheets, one per region, each of these sheets lists employee id numbers, each employee has an id number for each sales area, some id numbers are the same in different sales areas. This is the sheet I need to populate from the following:
Spreadsheets for each area (twelve areas)listing the employee id number and the number of sales they have achieved for different product types.
How do I get the data from my 'area' sheets to my 'region' sheets ensuring that the correct data referenced to the employee id number goes to the correct 'region' sheet.
You help would be gratefully appreciated