Compare and move

Hello, I have a spreadsheet where I need to move unique data that exists on Sheet2 that doesn't exist on Sheet1. It is a spreadsheet to keep track of RMA's and the unique identifier is located in Column A on both sheets.

I do have code from another workbook that compares cells existing on 2 worksheets and then highlights the cell that is unique yellow or not unique to Red. How can I change the code to move the unique cell to the other sheet instead of highlighting it. Thanks.

Please Login or Register  to view this content.

Hi Charles, thanks for replying. The code you provided works for when the 2 sheets have a matching cell, is there anyway to change this so when a cell does not match it will copy the data over to the other worksheet?

thanks again!

Originally Posted by Charles

Hi,

Are you wanting to move data if match as well as no match?

Only if it doesn't match.

One word BRILLIANT.

That is awesome, thank you very much!!!!!