Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down menu and validation over mulitiple sheets
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The drop down menu of my validation list needs to display more. | Excel Discussion (Misc queries) | |||
mulitiple cells in a drop down | Excel Discussion (Misc queries) | |||
Validation- Drop Down menu size | Excel Discussion (Misc queries) | |||
How do I create a Calendar Drop Down menu for a Validation cell | Excel Worksheet Functions | |||
How do I set up a drop down menu for a validation list? | Excel Worksheet Functions |