Convert Worksheet Change to Module

[infernojaffa]

Hi Guys

Firstly, I know nothing of vba.

I have a worksheet change macro which scans a column (starting form 8 down) waiting for the value "yes". When true it copies the whole row and pastes it into an archive sheet, deletes the original while keeping columns A-B.

This works great but i would like to convert it to a button when clicked the action will search the whole column (starting from 8 down) and archive any rows with yes in, delete the original while keeping columns A-B.

My current code is below:

Please Login or Register  to view this content.

The reason for this change is that i archive a lot at once and this current code takes around 5s per yes. If i was able to update all to yes and then click GO this should be faster.

I have also attached the current sheet.

Thank you in advance.
Andy

[Mumps1]

Try:

Please Login or Register  to view this content.

[infernojaffa]

Try:

Please Login or Register  to view this content.

Hi Mumps1,

Thanks for the help, it works!
I have one thing left for this code, my previous code copied format and text whereas this copies formulas.
Is there a way I can copy the same way?


EDIT:

I got it to work

Please Login or Register  to view this content.

[Mumps1]

Glad it worked out.

[infernojaffa]

Glad it worked out.

Hi Mumps1,

Actually this isn't working on some occasions. Sometimes just the text will be copied and other times it will copy formula.
I'm hoping to only copy values and format.
Are you able to provide any help on this matter?

Thanks
Andy

[Mumps1]

Try:

Please Login or Register  to view this content.

[infernojaffa]

Try:

Please Login or Register  to view this content.

Perfect!
Thank you.

[Mumps1]

You are very welcome.