Prev: How do i invert text in Excel
Next: using excel cells to be inserted into Ms.Word fill-in fileds
From: walrus on 14 May 2010 03:48
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?
From: Roger Govier on 14 May 2010 04:31
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?
First  |  Prev  | 
Pages: 1 2
Prev: How do i invert text in Excel
Next: using excel cells to be inserted into Ms.Word fill-in fileds