Jeff,
I'm pretty handy with excel but wouldn't call myself and expert. I am not entirely sure what you are trying to accomplish. If you just want a dropdown list to have new choices appear when you enter new entries into a column associated with the dropdown list then the answer is simple.
For the cell that has the data validation/list in it just modify the range to include rows beyond your existing last row. when new entries are made they will automatically be added to the choice in the dropdown list.
Example:
Say you have data in cells A2:A20 and this corresponds to an existing drop down list. In the cell that contains the data validation/dropdown list just make the range something like A2:A100 (or whatever you think the greatest row number will ever be including future entries.) If you enter data into A:21 it will show up in the dropdown list. if you add data into cells A22 it will then be added into the list and so on.
There may be a better way to accomplish this but this seems the easiest.
Forgive me if this is not what you are trying to accomplish.
Last edited by terzaghi; 08/24/10 01:18 AM.
