Dear Everyone,
I would like to request for help from anyone with regards of inserting data using VBA / Macros after Submit Button is clicked.
In the attached Client List sample CLIENT LIST SAMPLE.xlsm, I have two worksheets:
- WORKSHEET 1: INPUT - there's a table named as InputTable
- WORKSHEET 2: CLIENT LIST - there's a table named as ClientTable
What I want to do is, if someone enter the data in the InputTable[[DATA]:[DATA]] the data will be submitted and copied into new row in the ClientTable after Submit Button is clicked.
The reason why I need this to be happening is that, I don't want other users to change the data (either unintentional deletion of data or data overwritten) in the ClientTable.
So, I would be happy if anyone out there can help me out on this one.
I am thanking you in advance for your help.
Regards,
Adam
Bookmarks