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 01:51
How can i create a list (from Data Validation) based on data in another
sheet or work book?
From: Jacob Skaria on 14 May 2010 02:39
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: walrus on 14 May 2010 02:47
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: walrus on 14 May 2010 02:52
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?
From: Jacob Skaria on 14 May 2010 02:53
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?
 |  Next  |  Last
Pages: 1 2
Prev: How do i invert text in Excel
Next: using excel cells to be inserted into Ms.Word fill-in fileds