View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Galway[_2_] Galway[_2_] is offline
external usenet poster
 
Posts: 10
Default Macro help please

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