Attempting to use data Validation

I am attempting to use Data Validation to create a lookup from a different
sheet. What do I need to input into the Source Field so that sheet 1 will
pull data from sheet 2? I can see that the souce will populate =$A$2:$A$6.

Ron
Fri Mar 14 13:22:07 CDT 2008

When referencing another sheet with Data Validation,
you'll need to assign a Range Name to the source list.

Example:
To use a list on Sheet2 for a DV on Sheet1

Select the source list range on Sheet2.

From the Excel Main Menu: <insert><names><define>
Names in Workbook: (assign a descriptive name....like: myDVList)
Refers to: (make sure the proper range is selected)
Click [OK]

Then on Sheet1
<data><validation>
Allow: List
Source: (press [F3] to see a list of Range Names...select the one you need)
...finish the DV settings and Click [OK].

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Rudivin" <Rudivin@discussions.microsoft.com> wrote in message
news:6EAB37F5-0B04-4305-B6F4-B93BB1DD4F6E@microsoft.com...
>I am attempting to use Data Validation to create a lookup from a different
> sheet. What do I need to input into the Source Field so that sheet 1 will
> pull data from sheet 2? I can see that the souce will populate =$A$2:$A$6.

Mika
Fri Mar 14 13:35:52 CDT 2008

Hopefully this helps:

Make a named range of this particular range in the Sheet2
In the Data Validation window, as cursor is blinking in the field source
press F3 for the named ranges
From the list choose the Range Name for the source to be used
Choose OK

Regards,

Mika Oukka
IT-Consultant
Finland, Helsinki

"Rudivin" <Rudivin@discussions.microsoft.com> wrote in message
news:6EAB37F5-0B04-4305-B6F4-B93BB1DD4F6E@microsoft.com...
>I am attempting to use Data Validation to create a lookup from a different
> sheet. What do I need to input into the Source Field so that sheet 1 will
> pull data from sheet 2? I can see that the souce will populate =$A$2:$A$6.

Rudivin
Fri Mar 14 13:34:08 CDT 2008

That is exactly what I needed. Thanks!

"Ron Coderre" wrote:

> When referencing another sheet with Data Validation,
> you'll need to assign a Range Name to the source list.
>
> Example:
> To use a list on Sheet2 for a DV on Sheet1
>
> Select the source list range on Sheet2.
>
> From the Excel Main Menu: <insert><names><define>
> Names in Workbook: (assign a descriptive name....like: myDVList)
> Refers to: (make sure the proper range is selected)
> Click [OK]
>
> Then on Sheet1
> <data><validation>
> Allow: List
> Source: (press [F3] to see a list of Range Names...select the one you need)
> ....finish the DV settings and Click [OK].
>
> Does that help?
> Post back if you have more questions.
> --------------------------
>
> Regards,
>
> Ron
> Microsoft MVP (Excel)
> (XL2003, Win XP)
>
> "Rudivin" <Rudivin@discussions.microsoft.com> wrote in message
> news:6EAB37F5-0B04-4305-B6F4-B93BB1DD4F6E@microsoft.com...
> >I am attempting to use Data Validation to create a lookup from a different
> > sheet. What do I need to input into the Source Field so that sheet 1 will
> > pull data from sheet 2? I can see that the souce will populate =$A$2:$A$6.
>
>
>
>
>

Ron
Fri Mar 14 13:36:34 CDT 2008

You're welcome!

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"Rudivin" <Rudivin@discussions.microsoft.com> wrote in message
news:DCBFCEF9-FF1A-4B5C-A9A3-F69C79952C04@microsoft.com...
> That is exactly what I needed. Thanks!
>
> "Ron Coderre" wrote:
>
>> When referencing another sheet with Data Validation,
>> you'll need to assign a Range Name to the source list.
>>
>> Example:
>> To use a list on Sheet2 for a DV on Sheet1
>>
>> Select the source list range on Sheet2.
>>
>> From the Excel Main Menu: <insert><names><define>
>> Names in Workbook: (assign a descriptive name....like: myDVList)
>> Refers to: (make sure the proper range is selected)
>> Click [OK]
>>
>> Then on Sheet1
>> <data><validation>
>> Allow: List
>> Source: (press [F3] to see a list of Range Names...select the one you
>> need)
>> ....finish the DV settings and Click [OK].
>>
>> Does that help?
>> Post back if you have more questions.
>> --------------------------
>>
>> Regards,
>>
>> Ron
>> Microsoft MVP (Excel)
>> (XL2003, Win XP)
>>
>> "Rudivin" <Rudivin@discussions.microsoft.com> wrote in message
>> news:6EAB37F5-0B04-4305-B6F4-B93BB1DD4F6E@microsoft.com...
>> >I am attempting to use Data Validation to create a lookup from a
>> >different
>> > sheet. What do I need to input into the Source Field so that sheet 1
>> > will
>> > pull data from sheet 2? I can see that the souce will populate
>> > =$A$2:$A$6.
>>
>>
>>
>>
>>