How do you edit a drop down menu's location?
M Max Feb 21, 2010 #2 George said: How do you edit a drop down menu's location? Click to expand... 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
George said: How do you edit a drop down menu's location? Click to expand... 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
G Gord Dibben Feb 21, 2010 #3 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
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
