extract the added data

Sandy · 08-26-2005, 11:05 PM

We have a workbook with a large list of names and email addresses, problem is that 2 people have copied the sheet and added extra names and email's to each of there sheets. I need a way to extract the added data so they can be added to the original. Is this possible?

Sandy

mas · 08-27-2005, 06:05 AM

At least on Excel 2002 you can track changes by Sharing Workbook.
If you go to [Tools>Share Workbook] and turn on sharing function then
the track changes will be started.
After it is turned on, Excel helps to keep change history for you.

mas
-----
http://sapass.metro.client.jp

Sandy · 08-29-2005, 01:05 AM

yes I can understand this, but it is too late for this instance.

is there some way if we paste the larger email address list into say column
F and the original email addresses were in column C, is there some way to
get it to say if an address in column F is in column C ? then we could sort
by the result and copy the extra data ??

Sandy.
"mas" <mas_detokyo@yahoo.com> wrote in message
news:1125134029.190277.175190@o13g2000cwo.googlegroups.com...
> At least on Excel 2002 you can track changes by Sharing Workbook.
> If you go to [Tools>Share Workbook] and turn on sharing function then
> the track changes will be started.
> After it is turned on, Excel helps to keep change history for you.
>
> mas
> -----
> http://sapass.metro.client.jp
>

**mas_detokyo** · 09-02-2005, 07:33 AM

What you want can be done either by 'VLOOKUP' function or 'MATCH'.
Assuming you have updated address in column C and original address in Column F.

Put below formula say column D.
=VLOOKUP(Cn,F:F,1,0) or =MATCH(Cn,F:F,0)
For the entries you get other than "#N/A" is on column F.

If you don't like re-calculation, you can make this into VBA code.

Regards,
mas