List Drop-Down boxes data to a table

DMFisher

New Member
Joined
Apr 22, 2016
Messages
35
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)
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,099,007
Messages
5,465,981
Members
406,458
Latest member
Barboza Babcock

This Week's Hot Topics

Top