View Single Post
  #1   Report Post  
Cantor Lieberman
 
Posts: n/a
Default merging data from two different sheets

As Cantor of a large synagogue, I'd like to have membership data on my palm
pilot. My office provided me with two files:
1. Includes ID, names, addresses, birthdates, phones...etc.
2. Includes ID, children's names and birthdates.

Using the ID as the common link, how can I easily merge the correct
children's names with parental records, creating one file which I can import
to Outlook and thus sync with my palm.

Appreciate your help!
Robert