From: George on 20 Feb 2010 17:05 How do you edit a drop down menu's location? -- Thanks, George
From: Max on 21 Feb 2010 02:44 "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 21 Feb 2010 13:05 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?
|
Pages: 1 Prev: Open Workbook at a certain time Next: Workbook pivot table design function |