Hi,
I have a large spreadsheet master file which holds a membership record together with a unique membership number. From time to time I am supplied with updated membership details file - also quite large. This file contains some new memberships and others with just changed details.

I need to copy the update details file into the master file and:
1) if no duplicate is found (based on membership number) just add the record, or
2) if a duplicate is found (based on membership number) then replace the whole record with the new details from the update file.

Can anyone help me here - I have tried everything I can think of with no success.

Thanks, PaulB