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(0
10,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
___________________________
Kenneth Wonderley
http://www.wonderley.com...the fruit of the Spirit is love, joy, peace, patience, kindness, goodness, faithfulness, gentleness and self-control.
Galatians 5:22 & 23
