One guess as to the root Q here. Use named ranges as DV sources for better
flexibility. Then you can set the DV up easily to work across sheets as well.
Any joy? hit YES below
Location of the dropdown or location of the list range for the dropdown?
Cut and paste should get you the first.
In DV>List>Source dialog you should be able to change the list range.
Gord Dibben MS Excel MVP
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.
