Many thanks for that. The problem is that the other person adds a member by
name and allocated a membership number which also doubles up as a login to
the club's website. This number is the person's surname plus a number
(smith123).


"ScottO" wrote in message
...
Would this give you what you want ...

At the end of the month, your friend has the "official" copy of the file.
In a spare cell - say G1 - enter the last registered member ref#.
I say "enter" so that this is a fixed value, and not a formula like
=Max(MemberRefNum) which will increase if more members are added during
the
month.
Then apply conditional formatting to highlight all members with ref# the
entry in G1.
That way whenever your friend (or your friend's friend) adds members, they
will be formatted with whatever highlight you choose.

Rgds,
ScottO

"Ted Rogers" wrote in message
...
| 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
|
|