Hi,

I am trying to copy data to a new sheet and having some problems.

I need to copy all passes and faileds to a new sheet and work out the
percentage.

Column R contains whether the item is a "Pass" or "Fail" and is
automatically filled in by the formula
=IF(OR(D3="Y",I3="Y",J3="Y",P3="Y",Q3="Y"),"Pass", "Fail").

I have the following code copied from elsewhere on this site, but it does
not work. Returns the message "There are no items to move."!

Also, once complete, how do I assign the macro to a button on the toolbar?

Any help would be gratefully received as it would automate a very laborious
task!

JDB.