Duplicate Records???

[MarshallLaw]

Good morning,

I have a list of about 600 phone numbers and names that are associated to those numbers. I haven't been able to update it easily since I started keeping it and I was hoping someone here might have a good idea on how to solve my issue.

I have the list of 600 or so numbers with a name associated to it. I could add a third column that would contain an "updated" date in it. I need a formula or a macro that looks at each number, the date it's from, compare it to a new list of numbers and names and update it if there has been a change.

Can anyone help me?

Thanks!

 

[BrianB]

If it is a new list there is no need to worry about the date.
Make a backup first.

All you need to do is make a new temporary column with a VLOOKUP() formula to the new list. You will probably get lots of #N/A which you can ignore.

Copy the column and whilst still selected Edit/paste Special Values to change the formulas to values. Do a sort to get all the found values together (away from the#N/A). Copy/Paste the new numbers from the temporary column. Delete the extra column.