Dropdown List....

B

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
 
D

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"
 
B

Bob Barnes

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

Thank you - Bob
 
Top