fareedexcel
Member
Hi Experts,
I have attached a file with Macro which should do the following functions, but I'm getting an error.
The functions are,
1. I need to capture and save the Contact details (Mob No & Email Id) in Sheet 4 (Contact Info Sheet)
2. After entering the ERP No in D4, for the first time i will manually enter the email ID and Mob. No data in J4 and K4. When I click the button,after getting the confirmation message, the contact details should be saved along with the ERP No in Sheet 4.
3. This data in Sheet 4 is captured for future references. In case in future if the contact details exist in Sheet 4, then after typing the ERP No second time it should fetch the data from sheet 4.
4.And if required updating the existing record in J4 and K4 should overwrite the contact details in Sheet 4 after clicking the button.
This is my requirement and I have updated the Macro codings. But still my requirement is not fulfilled.
Please assist.
I have attached a file with Macro which should do the following functions, but I'm getting an error.
The functions are,
1. I need to capture and save the Contact details (Mob No & Email Id) in Sheet 4 (Contact Info Sheet)
2. After entering the ERP No in D4, for the first time i will manually enter the email ID and Mob. No data in J4 and K4. When I click the button,after getting the confirmation message, the contact details should be saved along with the ERP No in Sheet 4.
3. This data in Sheet 4 is captured for future references. In case in future if the contact details exist in Sheet 4, then after typing the ERP No second time it should fetch the data from sheet 4.
4.And if required updating the existing record in J4 and K4 should overwrite the contact details in Sheet 4 after clicking the button.
This is my requirement and I have updated the Macro codings. But still my requirement is not fulfilled.
Please assist.