I've created a worksheet with a series of drop down boxes with text based values. I used Forms, not the Control Tool Box to create the drop down lists. For example, there is a row that lists a criteria or a question, then under each relevent category or column there is a drop down box for which the user selects a value, for example; Available, Not Available, Partial, etc. What I want to do is once the user makes their selection to be able to automatically create create another worksheet that grabs the text values a user selects from the drop down in each column along each row, assign a predifined number value to those text values and then Generate a chart.

Hopefully this makes sense.

I was also wondering if there is a way to put sublists in a drop down, sort of like the windows start menu has where a selection has an arrow to other selections.