Macro to copy row if it contains any values

[strud]

Hi guys!

Pretty much what the title says I need a macro to copy rows to another work sheet if they contain values.

Also, I need it to to copy only the cell values rather than than the formulas.

Finally, I need the values to be copied onto the first blank row of the work sheet where they will be placed (say Sheet2) as opposed to just in row 1.

Any ideas?

Thanks in advance...

[ragulduy]

Something like this:

Please Login or Register  to view this content.

might do what you want but it relies on there being something in Column A each time you paste it across and it won't count 0 as a value.

[strud]

Sorry for the delay in getting back to you.

Just tested it and it works perfectly, thank you for the help!

Much appreciated.

Something like this:

Please Login or Register  to view this content.

might do what you want but it relies on there being something in Column A each time you paste it across and it won't count 0 as a value.