Hi all,

I hope it is a correct group for asking this question.

I need to have a combi - field in one of the worksheets. The content
of the combi - box should be filled dynamically according to external
data imported from SQL database.
Whenever value from box is selected, all other values connected to
this particular specified value are automatically filled in.

For example, I have a table of Customers:
Code | Name | Address |
-----------------------------------------------
Code_A | Name_A | Address_A |
Code_B | Name_B | Address_B |
Code_C | Name_C | Address_C |

So, in the combi - box I want to see only "Code_A", "Code_B",
"Code_C", but whenever value is selected, cells let's say C4 and D4
are filled either with Name_A and Address_A, Name_B and Address_B or
Name_C and Address_C.

How can I achieve this?

Thanks for any help

Chris