Iceberg
Board Regular
- Joined
- Mar 12, 2008
- Messages
- 79
Hello,
A co-worker has asked me to develop a macro for her. She's pulling two separate reports in SAP and the results get dumped into two separate spreadsheets. The first gives a complete employee listing and the second gives a list of employees who have completed training (both lists contain names and employee numbers).
Since the listings have hundreds of employees, she's looking for a macro that will compare the two. Duplicates will mean that the employee has been trained while single entries mean that the employee hasn't yet undergone training. The output should contain the names and employee numbers, as well as their status (trained/untrained). Since she will be pulling this list several times a month, ideally it would be something that she could run herself.
I've searched similar threads for ideas and am thinking that I may be using VLOOKUP for this. Having said that, I'm a complete VLOOKUP noob and would certainly welcome any advice.
How best do I go about tackling this?
Thanks in advance...!
A co-worker has asked me to develop a macro for her. She's pulling two separate reports in SAP and the results get dumped into two separate spreadsheets. The first gives a complete employee listing and the second gives a list of employees who have completed training (both lists contain names and employee numbers).
Since the listings have hundreds of employees, she's looking for a macro that will compare the two. Duplicates will mean that the employee has been trained while single entries mean that the employee hasn't yet undergone training. The output should contain the names and employee numbers, as well as their status (trained/untrained). Since she will be pulling this list several times a month, ideally it would be something that she could run herself.
I've searched similar threads for ideas and am thinking that I may be using VLOOKUP for this. Having said that, I'm a complete VLOOKUP noob and would certainly welcome any advice.
How best do I go about tackling this?
Thanks in advance...!