I have looked high and low for something relating to this, but have come up with little.
Unsure whether to post this in functions or VBA since there may very well be answers in both.
Current situation. I have a data set that is being used as a Data Validation forced input for a spreadsheet. However, all the possible entries to the sheet are not in the data validation set initially, and need to be added as they are entered.
The setup has my Data Validation table. The data is set up as a table in a separate sheet. Utilizing a table, the entries are able to expand as I need them by referencing the table.
My question is, if a free text is entered into a cell with a data validation drop down menu, how can I have it append to the end of the table if it does not already exist?
Current example is attached.
Thank you very much.
Bookmarks