Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do set data validation using cells on a different worksheet?
Can we use a range of cells for a data validation list which is on a
different worksheet? Each month, we open a new worksheet for queries received and we want the same range of options available as a list in our 'query type' column. We've used a data validation list drawn from a list of several options, and would like to reuse the same data validation conditions on every sheet. At the moment we can't seem to give a worksheet reference in the data validation options. Can this be done? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do set data validation using cells on a different worksheet?
Yep. You can give that list a nice name.
See Debra Dalgleish's site: http://contextures.com/xlDataVal01.html#Name Paul wrote: Can we use a range of cells for a data validation list which is on a different worksheet? Each month, we open a new worksheet for queries received and we want the same range of options available as a list in our 'query type' column. We've used a data validation list drawn from a list of several options, and would like to reuse the same data validation conditions on every sheet. At the moment we can't seem to give a worksheet reference in the data validation options. Can this be done? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do set data validation using cells on a different worksheet?
Yes it can.
Check out this web page of Debra Dalgleish: http://www.contextures.com/xlDataVal05.html -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Paul" wrote in message ... Can we use a range of cells for a data validation list which is on a different worksheet? Each month, we open a new worksheet for queries received and we want the same range of options available as a list in our 'query type' column. We've used a data validation list drawn from a list of several options, and would like to reuse the same data validation conditions on every sheet. At the moment we can't seem to give a worksheet reference in the data validation options. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data | Excel Worksheet Functions | |||
Display cells with data validation | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Automatic Data Validation drop down creation | Excel Discussion (Misc queries) |