Update a data validation list when a vlaue entered in the cell is not in the data validation list

Ezrin Feyd

New Member
Joined
Apr 6, 2019
Messages
2
Hello,

I have multiple sets of tables in a worksheet that I use for data validation lists. I can dynamically add new items to the tables and they will show up in the drop down lists in my worksheet. I would like to know if it is possible to add to the tables via the cell with the data validation list if the entered value is not in the list.
Example:

Data Entry Sheet Data Validation Sheet
Name Sport Sport
Mark Football Baseball
David Baseball Football
Steve ?

I would like to click the drop down and type in soccer (I do have the error alert turned off) and have soccer added to the sport table on the data validation sheet. Is this possible?

Thanks in advance,
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Watch MrExcel Video

Forum statistics

Threads
1,098,987
Messages
5,465,844
Members
406,449
Latest member
gunner12

This Week's Hot Topics

Top