View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Trish Rice
 
Posts: n/a
Default URGENT - Merge/compare workbooks

I have two worksheets with a common unique identifier for each employee. One
worksheet has the date of employment, and the other worksheet has a list of
training courses that have been completed by each employee. I need to
identify employees hired within a date range and check to see if they have
all completed their courses. This would be fairly easy if I could merge the
spreadsheets and sort by date of employment. I've been told that the best way
to handle this is to do a comparative analysis using vlookup, but I can't
find any info on that process.

PLEASE HELP!