Dynamically update cell content from data validation list

Hi everyone,

I have already had a look at existing threads on the subject from 2005 but cannot get my head around it.

I want to be able to dynamically update a cell content from a data validation list, without having to re-select the instance on the drop down list.

I would have on one sheet a list of cells that would form the basis of my data validation drop-down list and on another sheet the drop down menu. The problem is, if I modify one instance of the base list, the already populated cell on my other sheet would not update without me having to manually reselect it:

List1 banana < if i change "banana" to "mango" in list1, I want the cell value to dynamically update to "mango"
apple
lemon
banana

I have experimented with the offset function but that doesn't seem to apply to drop down list.

I have some VBA experience but veryyyy basic but can pick up quickly : )

Please see workbook attached.

Thanks.

try something like this...

Please Login or Register  to view this content.

Hi there,

Thanks a lot for your answer. I did not manage to make it work but found a workaround with separate workbooks and hyperlinks.

Cheers.