I am using Excel 2010 a sample file is attached. On this sample there is merged cells, this is only an example file, the actual spreadsheets do not have merged cells. You can unmerge them if needed. I just did it to explain what I wanted. I am comparing 2 sheets for data and need to move rows of data from one sheet to the other based on the comparison. Or I need to delete the row. See the attachment.
Bookmarks