Drop down menu and validation over mulitiple sheets
Give the list in sheet1 a name......InsertNameDefine.
Name it MyList
In the DV list source enter =MyList
Now select the DV dropdown cell on sheet1 and copy.
Select sheet2 then SHIFT + click on last sheet.
Select C18 on activesheet and Paste.
You now have a DV dropdown in all sheets C18 referring to MyList.
Don't forget to Ungroup the sheets.
Gord Dibben MS Excel MVP
On Thu, 24 Jan 2008 12:03:01 -0800, NFaye
wrote:
Hello, I am working on a workbook that has a drop down menu in cell C18 on
sheet1. The list that it references is also located on sheet1 in a hidden
column.
Each of the sheets in my workbook are identical and I am wondering if there
is quick and simple method to duplicate this function on C18 of each sheet,
as opposed to having to manually validate each separately. As well, am I
able to make each C18 reference the "list" that has been placed in the hidden
column on sheet1? Or do I have to hide this list on each sheet as well?
I don't want to link the cells to sheet1, as the repsonse on each sheet is
likely to be different.
Any help would be great. Thank you!
|