Hi

I am wanting to create a drop down list, however, I want the list of values
to reside on a different worksheet, but when I do this, I get an error to say
that the values must reside on the same worksheet. My lists are +200 values,
and I wanted a central list I could refer to from multiple worksheets. Does
anyone know how I could achieve this?

Thanks in advance