Auto populate list

[jaycee]

Hi

I have a list of names that are used in a dropdown box.

What I would like to do is that if I had a new name added in the dropdown box it would auto add it to the list as well.

I did something similar in access a long time ago but have lost that database, to have a look.

Using Excel 2010

Many thanks

 

[Akashwani]

Hi jaycee,

It sounds like you need a Dynamic Data Validation List....

Excel Data Validation - Add New Items

Excel Magic Trick 549: Dynamic Data Validation List Drop-Down OFFSET or Table Feature? - YouTube

I hope that helps.

Ak