I have several workbooks to maintain and I want to be able to gather
information from all of them and filter them by different criteria. For
example, searching through all the workbooks, display only the rows that
contain the word "Item".

Is this possible? and How?

Maybe you could combine all the data into one giant worksheet and do the filter
from there.

Ron de Bruin has some sample code at:
http://www.rondebruin.nl/copy3.htm

crush wrote:

I have several workbooks to maintain and I want to be able to gather
information from all of them and filter them by different criteria. For
example, searching through all the workbooks, display only the rows that
contain the word "Item".

Is this possible? and How?

--

Dave Peterson