Organic Source Lists

beastiebill

New Member
Joined
Apr 13, 2004
Messages
36
I can make validation lists equal to a "fixed" source list, BUT is there a way to keep adding items to a list without having to rename that source list [and then reset the data validation to the new name of the source list]?

Specifically, I have a spreadsheet [with a validation list] that allows you to choose an employee from a source list. Employees come and go and I am constantly updating the source list.

To take it one step further, the original updated employee list is actually kept in another excel file. So, ultimately, is there a way to reference a constantly updated list in one file as a source list for an in-cell drop down in another file?
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Watch MrExcel Video

Forum statistics

Threads
1,114,037
Messages
5,545,667
Members
410,697
Latest member
srishtijain0708
Top