how to compare two sheets with repeating rows
 

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

how to compare two sheets with repeating rows
 

Show your layout. Is the info in strings as shown here on in columns???

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Alawi" wrote in message
...
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