Hello,
My manager has given me a project of collecting skills of all the employees.
I have made and sent out a Excel sheet for employees to fill and send it back to me. It asks the Empployee to enter the following details
Employee Name:
Employee ID:
Date of updattion:
There is whole list of skills against which they have to
- Self Rating (Scale of 1 to 3)
- Mention the Level of experience (A,B,C,D)
- Training Undergone (Internal/External) (Y/N)
- Certification Attained (Y/N)
There are about 350 Employees who needs to be covered.
I need to merge all the sheets that I get from all the employees.
Can somebody help me write a Macro to collate all the sheets in to one.
I can send the sample sheet from which the data needs to merged from.
Thanks in Anticipation
Stankov
Collating Data from Multiple Excel Sheets
RCQwerty
Hello Stankov,
ADG is right you'll want this information in a database, however the sheets have been sent out. So an extra step is required, no problem. I'll write it, but the problem is each sheet needs to be consistant. There can be no variation AT ALL between sheets. The more variations the harder it is to code.
When you send the sample sheet could you include a small breakdown of all the values, like you have here, so I know what data to expect. Also can you tell how you want the data to collated. Do you want a sheet per person, or all employees on one sheet (recommended) or do you want them written to a text file.
Email it to dsmyth at ntlworld dot com and I'll code it up. It will have to be towards the end of the week.
lilithinzion
If you have Access the data would be better stored in two tables. One table keyed by ID to hold the ID, Name and updated date; and a second table linked by ID to hold the data relating to the skills (probalbly iondexed by ID and skill).
You could use a simple form to specify the workbook to imort and directly read in the data with code.