Need help in Data validation auto update thing. Thanks

[pedie]

I have from K1:K12 the names of the employees
Suppose latter, whenever i add another name in k13 i want the date validation > list to pick up (i.e, auto update by itself whereever i apply the the validation.

This might be simple for many of you but not me...

Without macro will be ok, even with macro...ok! PED!

 

[Mr_Roscoe]

Pedie - maybe naming a range will solve this.

Highlight cells K1:K100 then from the toolbar go to Insert -> Name -> Define and type in the names in workbook field EMP_NAMES and click the ADD button and then the OK button.

In your validation the criteria should be a LIST and in the source field type =EMP_NAMES

So this will validate even if you add up to a hundred employee names in column K.

If you think you may exceed this over time, write a comment in cell K100 reminding you to increase the EMP_NAMES range (in the same way as when you created it).

Cheers, Ian R.

 

[pedie]

Still waiting...

 

[hiker95]

pedie,

Try:
Excel Data Validation - Add New Items
http://www.contextures.com/excel-data-validation-add.html

 

[pedie]

Roscoe that was perfect and easy to understand...thank you & thanks to hiker95 too.

Thanks it works!