Merging two worksheets into one.

[seanherron]

Hi there,

I'm the IT guy for a non-profit. I have two separate worksheets. One is our "master list" of donors, which contains the first and last names, addresses, amount donated, date donated, etc. of all our donors, each in separate columns. On that worksheet, there are about 1500 rows missing the amount donated value. I have another worksheet which contains about 900 first and last names and amount donated rows. All of the names in the 2nd worksheet are listed in the 1st worksheet but have no donation amount tied to them. Is there a way to merge these two worksheets so that the donation amount information information from the 2nd worksheet is put into the corresponding donor on the 1st worksheet?

I've attached a rough example of the worksheets I'm dealing with. Unfortunately I can't provide the actual worksheets as they include private donor information.

Thank you so much!