title: Excel VBA need macro to to find matching values and copy row
body: <p>I have two worksheets - Sheet1 and Sheet2.  Both Sheets contain a column named IDNumber that contains a unique customer ID number.  Sheet1 has customer order history, and Sheet2 has the customer mailing address.  Sheet1 has multiple instances of a single customer (one row for each individual order they placed).  I need to loop through the sheets, and check the IDNumber from Sheet1 against the IDNumber in Sheet2, and then copy the row from Sheet2 (mailing address) into Sheet1 in columns E - J.</p>