Hi,
Take a look at Debra webpage
http://www.contextures.com/xlDataVal02.html#TwoWord

"Makelei" wrote:

Hi,
Is there a way how to get sheet that has been filled with "Pick from
drp-Down list" method to be updated in a way that it would be possible to use
Data Validation?

BR
makelei