moving row to new sheet when conditions are met

I had a similar thread and that issue was solved quickly. so hopefully this an too.

I have columns:

(Issue#) (Complaint) (Bid #) (Po#) ( Dept) (Contact) (Vendor) (Received)

(Resolved) (Completed)

I need it when i input yes under completed, it moves that whole a sheet labeled with the corresponding Dept. So if under Dept it said "water" and i marked it yes for completed, it would move that row to a sheet labeled.

If you could give me the code to do that, maybe i can figure out how to add the other dept names i deal with. Thanks in advance.

this is for excel 2007

Will the dept be selected by a dropdown or will the values be entered?

Do you want the movement to happen instantly or will you select the status for each row and then click on a button?

I would like to use drop down menus, but can input the value if that is easier

and I want it to run when I use the a drop down menu in the "Completed" coloumn and select "yes".

Based on the columns stated in the 1st post, its not clear as to how many columns you have and which is the completed column.

Do you have 9 columns in total and completed is column 9 (column I)?

I edited the first post to help. I put parenthesis around each column name. There is ten in total.

Right click on the sheet containing the data and paste this code in -

Please Login or Register  to view this content.

I pasted the code into the Visual Basic but when i picked yes in column J nothing happened

Was it "yes" in the dropdown or "Yes" ?

Change this row

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Originally Posted by arlu1201

Change this row

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Got it to work. I select yes from drop down list and then i have to click on the cell containing the "Dept" name and then it moves it to new sheet. Is there a way to have it move when i select yes?

You have to select the dept first and then yes. It will move then.

Am glad it worked. I will look into it and see what i can do.

Is it a fixed date?

Change it to

Please Login or Register  to view this content.

The code is fine. It doesnt copy the data to the next sheet?

I got it to copy it to a new sheet but i have to type date, hit enter, then go back and click the dept again. Is there a way to do it so when i hit enter after typing the date it will move the row?

It will be good if you attach a sample file then so i can check.

here you go

Try this (since you do not have a dropdown anymore)

Please Login or Register  to view this content.