Other VB Help: Copy cells to sheet on cell criteria

Hi Guys,

I've having some issues, found odds and ends of code that partially work, but can't get them to do just what i want.

i have 2 main sheets, Data and Archive.

Basically what i want to do is click a button that will copy all rows, from row 10 down, where the value in column P for that row is a value (<> "") to the archive sheet.

Is this possible?

Thanks for advance for any help!

Rich

 

Any ideas please? i'm getting desperate!

Thanks

 

Have you tried recording a macro while performing the actions you want to achieve manually? Once you've got the base code generated, the rest can be added later.