Creating a list from another sheet or workbook
 

How can i create a list (from Data Validation) based on data in another
sheet or work book?

Creating a list from another sheet or workbook
 

Create a named range of data in another sheet and refer the named range in
the list source...

--
Jacob (MVP - Excel)


"walrus" wrote:

How can i create a list (from Data Validation) based on data in another
sheet or work book?

Creating a list from another sheet or workbook
 

How do i put reference of the named range in the source? the name is "_GL".

"Jacob Skaria" wrote:

Create a named range of data in another sheet and refer the named range in
the list source...

--
Jacob (MVP - Excel)


"walrus" wrote:

How can i create a list (from Data Validation) based on data in another
sheet or work book?

Creating a list from another sheet or workbook
 

I got it.

Thanks.....



"walrus" wrote:

How do i put reference of the named range in the source? the name is "_GL".

"Jacob Skaria" wrote:

Create a named range of data in another sheet and refer the named range in
the list source...

--
Jacob (MVP - Excel)


"walrus" wrote:

How can i create a list (from Data Validation) based on data in another
sheet or work book?

Creating a list from another sheet or workbook
 

Did you try

=_gl

--
Jacob (MVP - Excel)


"walrus" wrote:

How do i put reference of the named range in the source? the name is "_GL".

"Jacob Skaria" wrote:

Create a named range of data in another sheet and refer the named range in
the list source...

--
Jacob (MVP - Excel)


"walrus" wrote:

How can i create a list (from Data Validation) based on data in another
sheet or work book?

Creating a list from another sheet or workbook
 

Yes...

One more thing...the list is alphabetical and 600 items long so if i have to
go to somewhere in the middle or the end, i have to scroll all the way
there...any option to maybe auto-complete the text i am typing or go to at
the point where the type alphabets start or something else?


thanks..



"Jacob Skaria" wrote:

Did you try

=_gl

--
Jacob (MVP - Excel)


"walrus" wrote:

How do i put reference of the named range in the source? the name is "_GL".

"Jacob Skaria" wrote:

Create a named range of data in another sheet and refer the named range in
the list source...

--
Jacob (MVP - Excel)


"walrus" wrote:

How can i create a list (from Data Validation) based on data in another
sheet or work book?

Creating a list from another sheet or workbook
 

Hi

take a look at
http://www.contextures.com/DataValHeadings.zip
--
Regards
Roger Govier

walrus wrote:
Yes...

One more thing...the list is alphabetical and 600 items long so if i have to
go to somewhere in the middle or the end, i have to scroll all the way
there...any option to maybe auto-complete the text i am typing or go to at
the point where the type alphabets start or something else?


thanks..



"Jacob Skaria" wrote:

Did you try

=_gl

--
Jacob (MVP - Excel)


"walrus" wrote:

How do i put reference of the named range in the source? the name is "_GL".

"Jacob Skaria" wrote:

Create a named range of data in another sheet and refer the named range in
the list source...

--
Jacob (MVP - Excel)


"walrus" wrote:

How can i create a list (from Data Validation) based on data in another
sheet or work book?