I have three columns (A, B, C) on a sheet (Data) -- in column A
"names" are listed (one name can be listed multiple times) -- column B
is a list of "training courses" that the employee has taken -- and C
has a "date" that the course was completed. On a second sheet
(Matrix) would like a unique list of the names and in Columns B-Z R2
I have the courses listed out. I am looking for a macro that will run
through the data to find the name and course combination and return
the date completed on the Matrix sheet. Any help would be greatly
appreciated! Thanks

On Thu, 15 Dec 2011 10:06:41 -0800 (PST), Galway wrote:

I have three columns (A, B, C) on a sheet (Data) -- in column A
"names" are listed (one name can be listed multiple times) -- column B
is a list of "training courses" that the employee has taken -- and C
has a "date" that the course was completed. On a second sheet
(Matrix) would like a unique list of the names and in Columns B-Z R2
I have the courses listed out. I am looking for a macro that will run
through the data to find the name and course combination and return
the date completed on the Matrix sheet. Any help would be greatly
appreciated! Thanks

Take a look at Pivot Tables.

You could Insert/Pivot Table

Then drag
Names -- Rows
Courses -- Columns
Dates -- Values

Then right click on the dates and set things to show Max of Dates, and format as a date.

Change some of the labels to something agreeable and format to taste