Add to Data Validation Values From Data Entry Cell

Ryusui

New Member
Joined
Apr 15, 2006
Messages
29
Office Version
  1. 365
Platform
  1. Windows
Another request. 😬

Hopefully this makes sense, but I want to know if there is a way to add to the values of a Data Validation table directly from the cell that is referencing that table, instead of having to manually go to the Data Validation range and add the new values there.

For example:
  • User enters data on sheet "SUMMARY" between B7 and B36
  • B7:B36 have drop-down lists referencing Column A in "TABLE1" on sheet "Values"
  • "TABLE1" has data in columns B & C
  • When a value is chosen in B7:B36, the corresponding cells in column C & D auto fill using the data that corresponds to the cells in B & C from the value selected from A in "TABLE1"
  • Let's say "TABLE1" has values of 111, 222, 333, 444 in A; COMPANY, COMPANY2, COMPANY3, COMPANY4 in B; COMPANY DBA, COMPANY DBA2, COMPANY DBA3, COMPANY DBA4, in C
  • Error alerts are turned off, so the user can input their own values if desired

What I'd like to know, is if the user enters their own values into B, C, and D on "SUMMARY" - let's say they put 789 into B7, COMPANY NAME5 in C7, and COMPANY DBA5 in D7 - is there a way for those three new values to be automatically added to TABLE1? So when they move down to B8, B9, etc., their drop-down list now has 111, 222, 333, 444, and 789 - and if they choose 789 it will be able to pull the new values from TABLE1 that were added from C7 and D.

Thanks for any time and assistance given to my request! And I hope that wasn't a confusing blur of gibberish.
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top