Hi,
Is there a way of adding data that has been selected as drop down boxes into a table?
- I have added a list box as a data validation in cells D3, D5, D7, D9
- Can I add a button that takes this data and adds it to a table and then deleting the data in cells D3, D5, D7, D9 to allow the form to be used again?
- The table will need to add the data to any previously stored (so the data doesn't overwrite itself - the table should have multiple rows of data)
Is there a way of adding data that has been selected as drop down boxes into a table?
- I have added a list box as a data validation in cells D3, D5, D7, D9
- Can I add a button that takes this data and adds it to a table and then deleting the data in cells D3, D5, D7, D9 to allow the form to be used again?
- The table will need to add the data to any previously stored (so the data doesn't overwrite itself - the table should have multiple rows of data)
