Excel Code run when combox list item is selected.

I guess it's not that it runs at all times it's more like adhoc changes to it have it run.

Attached a basic version of what it does. It moves the rows with 1 in column e to another worksheet. Basis is i'm creating a survey and i only want the ones with x in them to be answered so only those get copied to worksheet. So whenever you are on the worksheet with the code it refreshes (thus constantly working). Ideally i'd i only wanted a few of the columns and rows to be copied over but that became too hard and then i only wanted this to happen when i selected specific item from the list and that's where i am now.

Hope this is clear. sorry if it's not.

Thanks.

So now the question is how can associate that with an item from a combo box? I ask because i'm going to have different versions of 'Marital Statue' like Marital Status 1, Marital Status 2, and for each it will be different what name i want to select.

You've been a lot of help.

I also received an error when i opened this

Compile error --Invalide reference pertaining to .usedrange

I've attached the file with the drop down. I added the ActiveSheet but now there is an error on .Columns?

So, i was trying to add the code to Combo box list and use case to select Private Sub Worksheet_SelectionChange(ByVal Target As Range) but don't think i was doing it right.

Did the above make sense?

Look at the updated version that is attached. I'd like it to work as it does not but with the drop down on the Sheet 1 tab. When i moved the drop down to Sheet 1 i was getting a blank screen and not what i get now when you pick the different drop downs.

Thanks again for you help.

On the attached i just sent when you pick Marital Status i get everything from Maryland but only those with 1 in Column E on the Copy AllRows Filled with 1 tab ; when i pick Marital Status_1 i get everything from MAryland but only those with 1 in Column F on the Copy AllRows Filled with 1 tab.

And that is how i want it to be but i'd like the Dropdown to be in Sheet1 and when i moved it to Sheet1 the drop down selections give me blanks on the Copy AllRows Filled with 1 tab.

Question: You know how the code currently selects all rows and columns. What would i have to change so that it would select spcific columns. Like for instance only all rows but only columns Name, Data of Birth, City, Own a Home and not Columns E-G to show on Copy AllRows Filled with 1?

Is it possible to just have the drop down or is the form needed?

Is it possible to just have the drop down without the form?

Thank you so much. All of this has made much more sense and now i've gotten the handle of it.

I think this will be my final question, i hope............After i select on of the drop downs the cursor seems to go to random places. How can i adjust it the code so the cursor always ends on the tab and cell i'd like?

thanks again.