Excel 2007 : Duplicate ID Problem With Matching

[SOADave]

Hi I just started using VBA in Excel a couple of weeks ago and I’m not that experienced yet. I will now describe my problem.

In column K of one worksheet I have ID numbers (starting on row 3), but unfortunately some of them are duplicates because of similarity issues.
I’m trying to lookup each ID number on another worksheet in column AD (starting on row 4).

Some of the values may no longer be found on the second sheet as they do not exist anymore, and new entries will not have the same ID numbers as the first sheet so you do not need to worry about that. If the ID number on first sheet is found on second sheet, then I need excel to grab the value in column of Z of the second sheet in the same row and put it into column N on the first sheet.

The corresponding ID number on the second sheet must then be cleared so that it does not get chosen by the next ID number.
This code does what I want, but is so unbelievably slow that it nowhere near practical. (Sheet4 is first sheet, 31 Jan 2011 is second sheet in this example)

Please Login or Register  to view this content.

Any help would be appreciated.

[SOADave]

Example file attached for data

[SOADave]

Ok now I think the file is attached. I do not use forums a lot.