From: George on
How do you edit a drop down menu's location?
--
Thanks,
George
From: Max on
"George" wrote:
> How do you edit a drop down menu's location?
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
--
Max
Singapore
---

From: Gord Dibben on
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


On Sat, 20 Feb 2010 14:05:01 -0800, George
<george(a)discussions.microsoft.com> wrote:

>How do you edit a drop down menu's location?