• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Move row to sheet 2 when criteria is met

G

G-Sails

New Member
Hi,
I'm very much an amateur with Excel. I realise this will have been a commonly covered subject, but having tried to work it out for myself by reading other posts etc, I just can't get it! Hoping someone will take pity on me and help. I can't stress enough how much of an excel amateur I am!

I have a small worksheet with values A3:I203. It is a basic list of jobs to be actioned.

A1:I2 are taken up by a title header and column titles. I've probably laid this out badly so can change if needed.

Columns A - D have details about the job and columns E - H are progression indicators as to how far along the job has got, with the option to assign a tick to the cell using a drop down when that stage is complete.
Column I is the final "job complete" column also with the option to assign a tick.

Incase it matters... The ticks are generated in the cell drop downs by selecting webdings as the the font for E3:I203 and setting data validation list to a source of "a"
This is probably a strange way to do it, but the only way I knew.

I would like a VBA that will cut & paste an entire row into Sheet 2 (lets call it "complete list") once the tick criteria has been assigned to that row in column I.

So basically sheet 1 shows all outstanding jobs, and sheet 2 shows all complete jobs which have been ticked in column I.

I hope that is all clear and someone is kind enough to try and help me out.

I should say that I'm obviously happy to change anything necessary about the layout of the sheet in order to make it work! I can also upload it if needed.
 
Wow, fantastic Chirayu, thank you so much!

I'm going to be really annoying now... Sorry I really should of thought of this before, but, what if I want to add to the list as new jobs come in.

For example if I insert a new row with a new job in it, it won't be subject to the macro because the parameters are set for the 60 rows that are there now right?

Or put simply, How do I add a row but still have the macro work?

Ideally I would be able to insert a row anywhere in the order, not just at the top or bottom.

I would expect to be adding a number of rows to this every week, on an ongoing basis. So would probably end up entering around 260 new rows over the course of a year.

Sorry to be a pain....
 
Just thought I'd update, so as not to waste anyones time...

I have managed to solve this myself now, having used the excellent resources and teaching on this site. Thanks all who've contributed to it.

I shall be endeavouring to learn much more about excel.
 
You must log in or register to reply here.
Back
Top