Thanks for all your help anyhow Max. I couldn't have done it myself.
It looks like Richard may have a solution. I'll try it out in the next
day or so.

Eric


On Tue, 6 Apr 2004 01:07:46 +0800, "Max" wrote:

Eric, you're welcome !
Thanks for the feedback.

I hope this last step isn't too difficult.
Unfortunately, it's proving to be so ..

Try as I did, guess I'm out of further suggestions
to offer you on the deleted records part.
Not sure if an integrated formula solution is possible here.

Perhaps others would step-in to offer you other alternatives.
Maybe a sub could be fashioned to take care of
the comparison / insertion of the deleted records ..

Good luck !
--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <atyahoo<dotcom
---
"Eric G" wrote in message
...
Hi Max,

Very nice! Thanks very much.
Everything that you coded for works nicely now.

There's just one thing missing. I don't know if you understood me
correctly.

For the records that were deleted from Sheet1, I need placeholders in
Sheet3 sort of like this:

....
Arsenault Michel 104B 104P 105B 102C
Astins Melissa 104B 101C 103C 101A
Atkins Tylor 109A 103M 101M 108P
DELETED DELETED
Ayles Stephen 108P 109P 105B 102P
Allen** New 105B 106P 109P 102A
Anderson** New 105A 105A 102D 106P
Arsenault** New 102A 101M 102D 103C

So if I've deleted Attwell Alex from Sheet1, Sheet3 should show the
above. Preferably DELETED in Col1 and Col2 as above, as I believe
these two fields need to be filled in.



Thanks! Eric