compare and replace excel macro - TechRepublic
Question
September 9, 2009 at 03:52 AM
isisescul

compare and replace excel macro

by isisescul . Updated 16 years, 10 months ago

Hello all, I’m in a tight spot and I’m hoping i could find someone to help me over here. The macro I need needs to compare the data in column A in the first sheet with the data in the second sheet, same column. If the data matches it needs to go to column B and to compare the data from there. If this value matches it will delete the content of the whole line. If the A column dosen’t match it needs to go to the next line. All the data on both sheets is text. You think it’s doable? Thank you for taking the time to read.

This discussion is locked

All Comments