Data entry form to populate certain table dependent on validation list

[nmorrow]

Hi,
I'm trying to create a data entry form/sheet. Where I can select a unit id from a validation list and enter a date and meter reading and then submit the data and it will append to the bottom of a table, specific to the unit selected, in a separate sheet.
I have an example sheet that I would like it to look like, there is only 3 tables in the tables sheet, but my intent is to have a separate table for each unit; 66 in total.

Thanks

[sktneer]

Welcome to the Forum.

Please try something like this...

Please Login or Register  to view this content.

In the attached, fill the form and hit the Submit button to submit the form data in the relevant table on Tables Sheet.

[nmorrow]

Works Perfectly,
Thanks heaps Sktneer

[sktneer]

You're welcome!

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

You may also say thanks to those who have put their time and efforts to help you in this forum by clicking the Add Reputation link under their posts, another way to say thanks.

[nmorrow]

i'll do it now, thanks.
One last question, is it possible to use 'enter' key to submit?

[sktneer]

Refer to the attached. So as per the code now, once you input the SMU in F7 on Data Entry Tab, the form data is transferred to the Tables Tab in the relevant Table. That's the only way you can use the Enter key to submit the form data.
You can delete the button if not required.

[nmorrow]

Thanks again sktneer

[sktneer]

You're welcome!