Need help in Data validation auto update thing. Thanks

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
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...:biggrin:

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

Mr_Roscoe

Board Regular
Joined
Mar 28, 2006
Messages
200
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

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
Roscoe that was perfect and easy to understand...thank you & thanks to hiker95 too.

Thanks it works!
 

Forum statistics

Threads
1,085,328
Messages
5,382,979
Members
401,812
Latest member
emelyan1379

Some videos you may like

This Week's Hot Topics

Top