One easy way is to use datafilterautofiltercopy/paste. If a continuing
need, record a macro modify to find the last row+1 on the destination sheet

--
Don Guillett
SalesAid Software

"Sally in Toronto" wrote in
message ...
Hi,

Can someone describe how I can automatically copy rows that meet a certain
criteria from one worksheet to another worksheet?

I am trying to create a summarry page with only those rows that contain
data
in the "detailed worksheet" get copied and inserted into the summarry
page.
I would like the rows in the summary worksheet to be inserted below each
other.
Is this possible?

Sally.