I want to find out a formula to match Reg No. for two workbooks. First work book is a master book I update everyday almost, next workbook I have employees name and ID numbers only, nos are in different cells than worksheet one. I want to get master file Reg no. to match the other work book and copy the birth dates. Basically both workbooks reg. no. to be match and add only b day to another colom.
workbook1 , A3:A200=Reg no. and L3:L200= birthdays workbook2, A3:A200=Reg no. and I want get birthday from other workbook to J:3:200