http://www.rondebruin.nl/copy5.htm

would be a start.

--
Regards,
Tom Ogilvy

"Jerry Foley" wrote:

I have a rather large multisheet workbook. I want to write a formula or macro
that will search the "A" column in each worksheet. If there is a number in
the column I want to copy the entire row to a different worksheet. This is
above my head and any support will be appreciated.

Jerry