MS Excel : Use combo box to load data from one sheet to another

[SDK^]

Hi,

I'm wondering if anyone can help me with the following Excel problem please.

In one sheet I have a list of ID, customers name, phone #, address, etc. Each row has a different customer with seperate columns for name, phone, address etc.
I would like to create a combo box that can be used to select the ID and then load their information into different cells on a different sheet.

Any ideas would be appreciated

Thanks

 

[Spuds]

Assuming that you are using the latest version of Excel, then in the Input Range for the combo box enter the range for the ID's. For the Cell Link value enter the value of a empty cell out of the way on the sheet you want to display the values on. The combo box should then be populated with a list of all the ID's and when one os selected it's value will put entered into the cell you specified in the Cell Link field.

Next up, assuming that the data is in rows (i.e. each row in the sheet is an individual customer) then a VLOOKUP should get you the values you want bases on the value in the Cell Link cell. The formula will look somethin like this:

=VLOOKUP(Z1,Sheet2!A1:F20,2)

Z1 is the Cell Link value, Sheet2!A1:F20 is the range containing all the data (With the ID value in column A) and 2 is the column in the range you want the data from so 2 for Name, 3 for phone, 4 for address and so on