Question Locked
compare and replace excel macro
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.