Conditionally move row to another sheet

**meast** · 08-04-2011, 03:34 PM

Hi,

Having trawled the net for some guidance, it looks very much like this is the place to come.

I'm trying to create a simple tracker document. When jobs are closed complete or closed cancelled I want them to move from the main sheet to seperate 'closed' or 'complete' sheets.

Proabably fairly simple for someone in the know - but I am way out of my depth, I have only a working knowledge of excel - having spent the evening battling with visual basic it is clear I have much to learn.

I have enclosed my work in progress which should help clarify what I'm trying to do.

Am new to the forum, in fact new to any forum - so any guidance on protocol would be very much appreciated.

Thanks in advance.

**watersev** · 08-04-2011, 03:47 PM

hi, meast, will it be acceptable for you to manually run the code whenever you want and it will cut cancelled and completed orders out and paste them to respective sheets?

**watersev** · 08-04-2011, 04:20 PM

sort of that, please check attachment, run code "test"

**meast** · 08-04-2011, 05:36 PM

hi watersev - that was quick! thanks so much.

the tracker isn't for me, it's for the boys on site - so ideally it would work automatically without having to re-run the macro.

when i run the code though, i lose the options in my drop down box for 'complete' and 'cancelled'. they are also no longer present in the key section to the right.

other than that, it works exactly how i asked.

fixable?

(had a look at the code - it made my eyes hurt!)