Trying to auto populate cells from drop down list choices

I am looking to auto generate a roster/schedule. I have a spreadsheet with shifts for each weekday that I need to populate every week with names to pick from a drop down list. the drop down list is made using data validation and looks at a dynamic named range to allow me to select only the people who are available to work a certain shift.

Is there a way to do this using vba? I found a similar question from years ago:

http://www.excelforum.com/excel-form...-down-box.html

Thanks in advance.

populate the cells referenced by data validation using vlookupnth.

Please Login or Register  to view this content.

thanks Leon for the advice. can you help me thru this please? is this in vba? will this allow me to manually override the random generated value using the drop down afterwards? please advise.