Hello
I am currently using this system for my data validation with dependent dropdowns from a sorted list:
http://www.contextures.com/xlDataVal13.html
As per the example above, the keywords used in the lists are in a seperate tab.
I was wondering if anyone would know how I can put the keywords in a seperate document (for example, somewhere on the network) and still have this work ok?
Attached is the document I use.
Thank you very much.