View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Irma A Irma A is offline
external usenet poster
 
Posts: 1
Default Matching names and combining worksheets

I have one worksheet that contains Last Name, First Name of an entire
organization.

I have another worksheet in the same file contains Last Name, First Name of
a specific group within that organization. This worksheet also contains 2
other columns of information of that group (courses completed, courses
attempted).

I am trying to combine these worksheets so that the Last Name, First Name of
the entire organization is shown and for those names that have a match with
the 2nd worksheet, the courses completed and courses attempted data is shown.