Macro for comparing two columns and returning those that weren't found

[kurtwagner]

Hi, I need a macro that does the following:

Compare the numbers in column A of the sheet "BW" with values of column B of the sheet "Freight". It should return in column E of sheet "BW" the values that are in the sheet "BW" column A but not in column B of sheet "Freight".

Any ideas?

[stanleydgrom]

kurtwagner,

See my request for you on your cross post here:

http://www.mrexcel.com/forum/excel-q...ent-found.html


Have a great day,
Stan (hiker95)