OK....
Is there any harm in adding a helper column with serial numbers in it to use
as an alternate member reference number?
You could keep track of the highest serial number issued by another spare
cell - say H1 - with a formula like =Max(A:A).
Then use the method described in my last post, but based on the serial
number.
I know it's getting convoluted, but it's the best my feeble abilities will
allow ...
Rgds,
ScottO
"Ted Rogers" wrote in message
...
| 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
| |
| |
|
|
|
|