Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Validation Tables For Drop Down list on a Separate Worksheet.
I need to create a validation table for a drop down list but I want to
reference a range on a separate worksheet. Is this possible? I cannot seem to get it. |
#2
|
|||
|
|||
Hi
to do this you need to give the range on the other sheet a range name (select the data, click in the little box to the left of the formula bar and above column A and type a name - no spaces and press ENTER). now return to you other sheet - select the range where you want the drop down box, choose data / validation - choose list, click in the source line and press the F3 - your range name should be displayed, selected it and press OK and it should work fine. For more details on using data / validation - check out Debra Dalgleish's website at www.contextures.com/tiptech.html Cheers JulieD "azelli1" wrote in message ... I need to create a validation table for a drop down list but I want to reference a range on a separate worksheet. Is this possible? I cannot seem to get it. |
#3
|
|||
|
|||
Thanks so much!
"JulieD" wrote: Hi to do this you need to give the range on the other sheet a range name (select the data, click in the little box to the left of the formula bar and above column A and type a name - no spaces and press ENTER). now return to you other sheet - select the range where you want the drop down box, choose data / validation - choose list, click in the source line and press the F3 - your range name should be displayed, selected it and press OK and it should work fine. For more details on using data / validation - check out Debra Dalgleish's website at www.contextures.com/tiptech.html Cheers JulieD "azelli1" wrote in message ... I need to create a validation table for a drop down list but I want to reference a range on a separate worksheet. Is this possible? I cannot seem to get it. |
#4
|
|||
|
|||
you're welcome
"azelli1" wrote in message ... Thanks so much! "JulieD" wrote: Hi to do this you need to give the range on the other sheet a range name (select the data, click in the little box to the left of the formula bar and above column A and type a name - no spaces and press ENTER). now return to you other sheet - select the range where you want the drop down box, choose data / validation - choose list, click in the source line and press the F3 - your range name should be displayed, selected it and press OK and it should work fine. For more details on using data / validation - check out Debra Dalgleish's website at www.contextures.com/tiptech.html Cheers JulieD "azelli1" wrote in message ... I need to create a validation table for a drop down list but I want to reference a range on a separate worksheet. Is this possible? I cannot seem to get it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List on different worksheet | Excel Discussion (Misc queries) | |||
Validation List and VLookup are ackting strange | Excel Worksheet Functions | |||
list validation using list validation... | Excel Worksheet Functions | |||
How do I create a validation list on a separate worksheet? | Excel Worksheet Functions | |||
Validation - List - Separate Worksheet | Excel Worksheet Functions |