Dropdown List....

[Bob Barnes]

I'm an Access Programmer.

How can I see "2 columns" of info in Excel like an Access dropdown..IE..

1 Apples
2 Bananas
3 Oranges

....which in Access comes from a SQL.

TIA - Bob

[Debra Dalgleish]

If you mean a data validation dropdown, you can use a worksheet formula
to combine the values in two columns, then show the combined values in
the data validation list. There's an example on the following page:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for "Data Validation Columns"


Bob Barnes wrote:
> I'm an Access Programmer.
>
> How can I see "2 columns" of info in Excel like an Access dropdown..IE..
>
> 1 Apples
> 2 Bananas
> 3 Oranges
>
> ...which in Access comes from a SQL.
>
> TIA - Bob


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[Bob Barnes]

Debra - Ah Yes...simple String concatenation.
WORKS like a Champ.

Thank you - Bob

"Debra Dalgleish" wrote:

> If you mean a data validation dropdown, you can use a worksheet formula
> to combine the values in two columns, then show the combined values in
> the data validation list. There's an example on the following page:
>
> http://www.contextures.com/excelfiles.html
>
> Under Data Validation, look for "Data Validation Columns"
>
>
> Bob Barnes wrote:
> > I'm an Access Programmer.
> >
> > How can I see "2 columns" of info in Excel like an Access dropdown..IE..
> >
> > 1 Apples
> > 2 Bananas
> > 3 Oranges
> >
> > ...which in Access comes from a SQL.
> >
> > TIA - Bob
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>