Hi folks,

This is the same kind of thing that I need to do with a sheet I have
with lots of content. I am having trouble editing the macros provided
above to work for my sheet. I would be most apreciative if anyone could
offer me some pointers as I have very little experience with macros.

Basically I have my sheet set up like this

Column A: Title
Column B: Company
Column C: Address 1
Column D: Address 2
Column E: Address 3
Column F: Town
Column G: County
Column H: Postcode
Column I: Category

I need to be able to search Column B (Company) so it will pull anything
out that has the word 'Pizza' anywhere in the company name and put that
whole row of information in another workbook.

I've got a file already called book1.xls which contains Sheet1 - this
is where the content is. This contains 25474 rows of our contacts.

And book2.xls which contains Sheet1 for where the rows it pulls should
be placed.

If it's not too much trouble could someone help me get this working?

Cheers,
Rose


--
musik
------------------------------------------------------------------------
musik's Profile: http://www.excelforum.com/member.php...o&userid=31087
View this thread: http://www.excelforum.com/showthread...hreadid=506510