I have workbook for customer booking. I am sharing small part of it to make it simple to answer.
I have two sheets. Entry sheet is used to enter customer ID in cell B2. I want:
- the ADD button to add the value entered to be saved in Table sheet in column A.
- Each time the user clicks the button the value to added in the Table sheet.
- But if same value entered then it should show error message box and ask to enter value again.
- There is another button which clears all the data but I have not added to this file cause I do not need any help with that so ignore it.
See the attached sheets.