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!
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

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!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,228
Messages
5,594,929
Members
413,953
Latest member
Arthur1471

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top