Removing all rows with word yes populated and pasting to new sheet

[mccrimmon]

Hi

Im wondering if you can help with what im trying to achieve.

I have a spreadsheet with a list of tasks on it (around 600 rows in excel)

Every cell in column AD is currently populated with the word NO.

Once each task is completed the word YES is typed into each row starting on Cell AD7.

I then was looking to have a macro button that we can press at the end of each day and it removes all the rows which have a Yes populated in column AD and paste them into a seperate sheet called "Completed Tasks" so it leaves only the outstanding tasks on the sheet "Outstanding Tasks"

These tasks can be completed in any order so cell AD450 could be populated with a YES and cell AD10 could still be sitting as NO.

Can this be achieved? Can someone help me out on this.

Cheers

McCrimmon

[boylejob]

McCrimmon,

Give this a try and see if it does what you are wanting.

Starts at the bottom of the Outstanding Tasks sheet and looks at each row up through row 7. If the value in Column AD of that row is equal to "YES" then that row is moved to the Completed Tasks sheet and deleted off of the Outstanding Tasks sheet.

Please Login or Register  to view this content.

[mccrimmon]

Beautiful work my friend!

Works a treat!

Im in the process of learning VBA so hopefully in the next month or so I will be up to scratch and not be posting on this forum unless its to help someone else

[boylejob]

McCrimmon,

Wonderful! I'm glad it worked and I could be of service.

Just out of curiousity, where are you located. I always find it interesting to see where in this small world questions come from.

[mccrimmon]

McCrimmon,

Wonderful! I'm glad it worked and I could be of service.

Just out of curiousity, where are you located. I always find it interesting to see where in this small world questions come from.

Edinburgh in Scotland.

Jeff - Could you do me a favour if possible and provide me some information as to what each line does? As I said above, im new to VBA and still trying to find my feet with the who program.

Thanks again

Much appreciated!

[boylejob]

McCrimmon,

Here is the code description that you asked for. I hope it all makes since, but if it doesn't, please don't hesitate to ask me about anything you don't understand.

Please Login or Register  to view this content.

I have been programing in VBA for about 7 or 8 years now. I just recently found this forum and it is absolutely fantastic. It is amazing what I have learned and how much better my code it now. If you are not sure about something don't hesitate to post to this list. There are some very talented folks monitoring this forum and you will almost always get an answer.

I started out asking questions and then decided to see if I could answer a few. Mudraker told me that answering question helped him learn even more and he was absolutely right. I have learned all kinds of new things simply by answering questions. There are often several ways of accomplishing the same task and by asking a question you might find an easier way of doing something. So ask question!!!!