how to compare two sheets with repeating rows

A

Alawi

I have two Excel sheets one is master roster of employees and the others
training courses( transactions file) taken by some of the employees. What I
want to generate a list that shows courses taken by each employees if any(in
the training sheet) and merge it in the roster sheet in fornt of each
employee.( some employees have several courses & each course appear as a row
in the Training sheet);i,e.

Roster:
Employee A number, name
Employee B number , name
Employee C number, name

Training Sheet:

Employee A number, name & course 1
Employee A number, name & course 2
Employee B number, name, course 4
Employee c number, name, course 1
Employee c number, name, course 2
Employee c number, name, course 4
Employee c number, name, course 7

so I need the result as follows:

Employee A number, name, course 1, course2
Employee C number, name, course 1, course 2, course 4, course 7

etc

I appreciate your suggestion
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
which one to use: Macros / Formula's / Lookup 4
Transpose large data from columns to rows 3
Selecting vertical rows and displaying them horizontally. 2
Selecting data from columns and displaying them as rows 2
Searching worksheet and exporting name to other sheet 1
database setup 1
Excell 2000 IF Statement 1

Top