| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
