Combo Box and Cell

  • Thread starter Thread starter Lord Of The Morning
  • Start date Start date
L

Lord Of The Morning

What im trying to do is transfer the information
selected from the combo box along with information
in a cell to another cell on a seperate sheet.

Here is an example of what im trying to do.

http://66.60.173.165/ExcelFile.xls

If someone could please give me some pointers I would
appreciate it.

Nick
 
Not sure I have understood you correctly but if I have, the following works
in your example when you manually type in text (city & zip fields), I have
not been able to get it to return the value from your combo box.

=CONCATENATE(Sheet1!B5," ",Sheet1!B7)

Hopefully this will give you a clue.
 
Well thanks for taking a look, Yeah im trying to get the state (from the
combo box)
the city and the zip from the appropriate cells to all transfer to one cell
on another sheet.
I will be spending the weekend trying to figure this project out.
Nick
 
Link your combo box to a cell, e.g. B3.
Then, enter the following formula in the cell where you want the city,
state, and zip code:

=Sheet1!B5&" "&INDEX(Sheet1!$F$3:$F$8,Sheet1!$B$3)& " " &Sheet1!B7
 
Wow That Worked!!
Thanks so much, I had to play with it a little bit to fit my project but
when I hit enter it
showed exactly what I needed.

Thanks,
Nick
 
Back
Top