Check out AutoFilter. Depending on just how your worksheet is set up you
might be able to set AutoFilter to select each client individually and then
just copy the visible cells.

Regards,

OssieMac



"galfriday905" wrote:

I have a workbook containing records of 18 clients with entries for each
month of the year since 2004. I can do a "find all" for all years to date,
but how do I copy or save the results for each client into a new worksheet?
--
jh