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

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

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