I have a workbook with several tables. I would like a system of simple forms for users to navigate between, filling up the little text boxes and selected from cute drop down lists. The various table will be filled and bob's your uncle.
The question I have is this:
Can I have users fill in one form. and save it. The info will be stored in one row in the appropriate worksheet table.
Then with the same form, the same text boxes etc. They add anothert record and the next row will be filled on said worksheet and so on on and so forth.
Like in access
I want them to be able to add as many records as they want.
The question I have is this:
Can I have users fill in one form. and save it. The info will be stored in one row in the appropriate worksheet table.
Then with the same form, the same text boxes etc. They add anothert record and the next row will be filled on said worksheet and so on on and so forth.
Like in access
I want them to be able to add as many records as they want.