I have two Excel spreadsheets (Sheet1 and Sheet2). Each sheet has several thousand rows of data. The first column in both sheets have unique data (MemberId) that may/may not match. Sheet2, has a NOTES column that may/may not have data. I need VBA code that will search MemberId in both sheets to find all matches. If/when a MemberId match is found, copy and paste the NOTES value in Sheet2 into a corresponding NOTES column in Sheet1. I am familiar with VBA code, but somewhat rusty...Thanks in advance!