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.

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" <(E-Mail Removed)> wrote in message
news:6EAB37F5-0B04-4305-B6F4-(E-Mail Removed)...
>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.

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" <(E-Mail Removed)> wrote in message
> news:6EAB37F5-0B04-4305-B6F4-(E-Mail Removed)...
> >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.
>
>
>
>
>

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" <(E-Mail Removed)> wrote in message
news:6EAB37F5-0B04-4305-B6F4-(E-Mail Removed)...
>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.

You're welcome!

Regards,

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


"Rudivin" <(E-Mail Removed)> wrote in message
newsCBFCEF9-FF1A-4B5C-A9A3-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:6EAB37F5-0B04-4305-B6F4-(E-Mail Removed)...
>> >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.
>>
>>
>>
>>
>>