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
Try:
Please Login or Register to view this content.
Last edited by Mumps1; 01-26-2020 at 12:22 PM.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Cheers for the quick response. Does the job fine. Is there a way of add the date to the end of the table rather than it sitting underneath? Or is that because it's pasting the whole row so it doesn't match the length of the table?
I don't see any date in either sheet. Can you please clarify in detail what you want to do?Is there a way of add the date to the end of the table rather than it sitting underneath?
Sorry, mistype, I meant data.
Try:
Please Login or Register to view this content.
Cheers. The seems to work fine. That sorted it.
Glad it worked out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks