I have an idea, but need a little help ... How do I programmatically run a macro on a value change in a cell?

Thanks for the response.

JD

>The only way I could think to do this is to select one of your 12 choices, then click a button that runs some VBA code. Or have just the VBA code in a button and when it is clicked, it starts with a message box that has the 12 selections. I don't think the VBA code to do something like that would be hard to write at all. If you start it and have problems, let me know.
>
>
>>I'm hoping someone will have an idea for me on this one. I have a drop down box w/ 12 choices. I want each of these choices to select one of 12 columns of data, and move that data's contents into a blank column.
>>
>>I can't use IF() because you can only nest 7 of these and I have 12.
>>
>>Here's the idea, though, using IF():
>>
>>IF(010,select column 1 and put it into blank column N,IF(1020,select column 2 and put data into blank column N,IF(........
>>
>>Does anyone have an idea for a better way to do this?
>>
>>Thanks
>>
>>JD