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:
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.
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.