Good afternoon everyone
I am using a form to enter data into a datasheet which then drives reports etc. I have some very basic VBA in the background.
I am curious to know if anyone has ever used a form to enter a range of Data, like using a template of tasks that are then added to a datasheet.
Eg .... If I select the entry "Drive Car" from a drop down list in my form, then the information placed into the datasheet of tasks is as follows:
Open Door
Sit in Drivers Seat
Put on Seat Belt
Start Car
Put foot on the brake
Put in Drive
Put foot on Accelerator
These entries would be a named range on a separate sheet called "Drive Car", so choosing the Name of the Range from the Drop Down would fill out the items in the datasheet as a list of items
I can get the task sheet to list the items by using a basic if statement, however the data sheet would be an ongoing list that can be added to at any stage, so the above example would make up 7 task lines in a longer list.
I have attached a basic sheet to show what I am after. I would like to select an item from the Yellow drop down list and have it put the list of tasks for that item in Columns A and B. I will have a "Submit" Button to confirm the entry.
If I then select another item from the yellow drop down, I want those tasks to be added beneath anything already in Column A and B, so it is an ongoing list.
Hope this makes sense.
Warm regards
Darren.
Bookmarks