Hi, welcome and thank you for your question. My name is XXXXX XXXXX I am glad to assist you today.
If you are using Excel 2007 or 2010, you just need to go to Developer tab, click on Insert then click on Combo Box Form Control. Here is my screen shot:
Then you draw your combo box and then right click on it then click on Format Control.
Then in the Input Range, click on the small icon with the red arrow to minimize the box, then click on the other sheet where the data are stored.
After selecting the sheet and the data, click on the icon with the red arrow again, or simply press Enter. Then click OK.
Then when you go to the combo box, the data selected will be shown as pull down values.
Click on this link to download the sample file I made for you:https://dl.dropboxusercontent.com/u/22865503/SampleComboBox.xlsx
I hope that helped. If you have time to rate my service, that is highly appreciated!
If you have any other questions, please ask me or reply to me – I’ll be happy to respond.