W
walrus
How can i create a list (from Data Validation) based on data in another
sheet or work book?
sheet or work book?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jacob Skaria
Create a named range of data in another sheet and refer the named range in
the list source...
the list source...
W
walrus
How do i put reference of the named range in the source? the name is "_GL".
W
walrus
I got it.
Thanks.....
Thanks.....
walrus said:How do i put reference of the named range in the source? the name is "_GL".
J
Jacob Skaria
Did you try
=_gl
--
Jacob (MVP - Excel)
=_gl
--
Jacob (MVP - Excel)
walrus said:How do i put reference of the named range in the source? the name is "_GL".
W
walrus
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..
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..
R