I have a sheet with 600 records (LastName, FirstName, Col3, Col4,
Col5,Col6).
My second sheet has 670 records with the same field headings but the
data is different in Col3, Col4, Col5, Col6 for ALL the records.

Can someone please tell me how I can sort Sheet Two so that the first
600 records are arranged in the same order as Sheet One's (Last Name,
FirstName sort) ?

I hope this makes sense.

Thanks! Eric