Needing a macro to transfer notes

[THRASHER69]

Hello,
I’m needing a macro that will look at column E and then column A on the BO Save sheet, compare it to the same columns on the Back Orders sheet, insert a blank line on the Back Orders sheet where needed, and then copy the note in red over from the BO Save sheet. So on the Back Orders sheet, it would insert a blank line after row 9, then copy over row 10 from the BO Save sheet to the newly inserted row on the Back Orders sheet. Next it would insert a row after row 10 on the Back Orders sheet and copy over row 12 from the BO Save sheet. This will continue till it reaches the end. If the row is on the Back Orders sheet but not on the BO Save sheet, I need it to do nothing (rows 31 – 35 on the Back Orders sheet). Same thing goes for the BO Save sheet. If a row is on the BO Save sheet but not the Back Orders sheet, do nothing (row 24 on the BO Save sheet). If someone could help me out it would be much appreciated.


Here is the spreadsheet:
BO Report.xlsx

[THRASHER69]

Also posted on MrExcel board as well. Here is the link

http://www.mrexcel.com/forum/excel-q...fer-notes.html

[THRASHER69]

posted a link in the other forum, which is listed above, to some code that somewhat works if anyone would like to look at it and give me some ideas as opposed to starting from scratch. not sure which would be easier. Thanks

[THRASHER69]

My issue has been resolved. Much thanks to p45cal. Here is the link for the new code:

Compare and Copy Code Trouble