Add to dropdown will save record in 2 sheets

[Jens_Damen]

Hi all

I have 2 sheets

• Sheet 1 houses the records for 2 of my dropdowns (enum with valid if selection to that sheet)
• Sheet 2 will save all data belonging to records (2 columns are the dropdown above)

Now I already figured out that I can use suggested values instead of valid if to allow new entries.
But this will only add this value in sheet 2 and will not add it to my sheet 1.

I’d like to create the option to make the dropdown grow by user input.
So when a user uses the add option it will get added to the record list in sheet 2 but the list for the enum will also get the new record.

How could I achieve this?