Hiya,
I need the code to be able to do the below. I've had a go but not come anywhere near.
Compare the cells in column 2 in Sheet2 against column 2 in Sheet1. If the contents of the cell matches the copy the cells in O:S on that row in Sheet2 to the corresponding row in Sheet1. If it doesn't match any then copy the whole row from Sheet2 and paste at the bottom of the list in Sheet1. Both lists will be of a variable length.
I hope that make sense. I've attached a sample workbook.
Tim
Bookmarks