Drop Down Problem

[stephen.smith]

Hi Guys
I am trying to create about 150 dropdown boxes in a column. All of the boxes will have the same cell input link but the output link will be different for each one. Is there a way to get excel to understand that the output will be different rather than formatting the control on each box. The output will be c2,c3,c4,c5 and so on. Any thoughts appreciated.

 

[Andrew Poulsom]

Can't you use Data Validation?

 

[stephen.smith]

I have no idea how to do that. Can anyone explain how to do that??

 

[Andrew Poulsom]

Look here:

http://www.contextures.com/xlDataVal01.html

 

[stephen.smith]

Hey cant seem to find how to do that there. Its the cell link im trying to change, rather than the input. It doesnt show how to do this here. Its actually a combo box I am using..

 

[Andrew Poulsom]

The link I posted shows you how to create a data validation dropdown. What you select is entered directly in the cell that contains the dropdown.

 

[stephen.smith]

I have it now, sorry I didnt understand it at first attempt, thanks