extract the added data

S

Sandy

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
 
M

mas

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
 
S

Sandy

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.
 
M

mas_detokyo

What you want can be done either by 'VLOOKUP' function or 'MATCH'.
Assuming you have updated address in column C and original address i
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,
ma
 
Top