It is taking to a new forum. Can anyone give a solution in this forum.
My request is,
1. I have two sheets, Form sheet & Master File sheet. In the Form Sheet, if I enter the ERP No, excel should check in the Master File Sheet whether data exists, if yes, then the data (Mob No & Email Id) should auto populate in the Form sheet.
2. In case if the data is not available in the Master File, then excel should allow me to enter the data manually in the Form sheet which inturn should auto populated in the Master File sheet (So we can use the data for future reference)
Please Help with a solution.