I have two separate excel workbooks, each with one worksheet. Both Workbooks/sheets host contact names, phone numbers and addresses. Workbook/sheet 1 is the master contact/address book. Workbook/sheet 2 is a weekly submission of contacts, some of which are already in Workbook 1. Every week I use the vlookup formula in Workbook 2 to cross-reference each phone number in Workbook 2 with those of Workbook 1. If there is a phone number match, I have the vlookup formula copy the phone number from Workbook 1 and paste it into the respective cell in Workbook 2. I do this with phone number, first name, last name, and a bunch of other data. The problem is that Workbook 2 is getting huge, and because I utilize hidden columns for formulas, I have a worksheet that's twice as large. I would like to place a button at the top of each column in Workbook 2 that cross-references the phone numbers in column A in Workbook 2 with those in Workbook 1, and if there is a match, the formula will grab the Contact Name (found in Column B of workbook/sheet 1), and paste it into the respective cell in Workbook/sheet 2, and if there is no match, then the cell does not change.

If anyone has any idea how to do this using VBA, please let me know. I purchased "Microsoft Excel VBA Programming - For the Absolute Beginner - Third Edition", so I am learning, but I'm still unable to meet my own needs.

Thanks for any help!