If you first give the list on sheet2 a defined name like MyName you can use
that defined name in sheet1 DV list source
Type =MyName into the source refedit dialog.
Gord
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.