How do I find data in one worksheet, transfer it to another in on.

[Rib71]

I'm constructing a spreadsheet in Excel2000. I would like to be able to
"find" all the instances of a particular text string e.g "jointing" within an
entire workbook - then all the instances, with relevant details from possibly
an adjacent cell copied through to another worksheet to enable just the
printing of that particular item.

 

[Ron de Bruin]

Hi Rib

Macro example

This example will copy all E-mail addresses to a other sheet
http://www.rondebruin.nl/find.htm#Copy