I have been asked to try and solve a problem that a friend has. (Please try
and ignore the workflow - I have suggested other ways of doing it but he
won't have it!). He has a spreadsheet containing around 1500 entries. These
consist of club members with an exclusive reference number each. My friend
is responsible for the overall membership but sends a copy of the file to
another person who operates within it month to month. At the end of the
period the file is sent back to my friend with new members etc. and my
friend then wants to import it into his file (which he has been amending at
the same time)

What he would like to do is to import this file, avoid duplications and
highlight in some way the new members (by maybe colouring the lines) to
distinguish them from old ones (the entries are sorted by surname so new
entries could appear in the middle of the sheet).

I hope this is clear, I know he's be better off using Access but he's been
using this for years and wants to do it this way. Is it possible please?

Many thanks,

Ted