Hello,

I need to build a macro that will complete copying a set of data from one workbook to the next based upon the first entry into the new sheet.

For example, say I have contact info about person A in workbook 1. Once I enter the name or ID # of person A into workbook 2, I would like the phone number, address, etc. of person A to appear.

Thanks for any help!