Sheet1 has lsit of crew names.

Sheet2 has details about the crew in the following manner.

a1 to a3 is merged as one cell for crew name. b1 will have residence, b2

his office, b3 his business.

The problem I am facing is when I link sheet1 names to sheet2, it is not

in same order in sheet2 becos three rows or merged as one cell.

so pls help me in

a) how to link names between two sheets to copy the names in sheet2 from

sheet1 and

b) I have all the data of names in access and it should be linked to this

sheet1.

Pls note using office 97.