PDA

View Full Version : Macro for comparing two columns and returning those that weren't found



kurtwagner
12-07-2012, 09:29 AM
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
12-07-2012, 12:33 PM
kurtwagner,

See my request for you on your cross post here:

http://www.mrexcel.com/forum/excel-questions/673434-macro-comparing-two-columns-returning-those-werent-found.html


Have a great day,
Stan (hiker95)