Loop to add string to bottom of a variable column

Hey guys,

So I have a drop down menu on a worksheet, with values that match up to columns on the same sheet. What I'm trying to do is when a user chooses a value from the dropdown menu and clicks the "run" button, a string (in this case "x") will be placed in the first blank row of the column that corresponds with the value of the dropdown menu.

I've had limited success so far, as I can get the "x" to appear in different places based on the selection in the dropdown menu, just no where close to where I want it to be.

The workbook is attached if anyone could provide some insight or suggestions or point out my mistakes.

Thanks

Here is some of the code as well

Please Login or Register  to view this content.

sActually I have one more question:

So that worked perfectly when all the data was on one worksheet, but how could I check the J2 value on the active worksheet and place the "x" in a worksheet called Lists ?

Nevermind, I played with the code and did it myself. Just created a second with statement for placing the outcome. Thanks!