View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dus@n
 
Posts: n/a
Default Adding data from another sheet

I have two sheets:
- sheet 1 contains: name; first name; number;....
- sheet 2 contains: name; first name; number; birth date....

All persons that are in sheet 1 are also in sheet 2 (but not vice versa).
Name, first name and number all same in both sheets.

I would like to add to sheet 1 birth date of each person fron sheet 2. How?