Need to create search function in excel 2010

[Rosscoe28]

Hi,

I have an excel book containing 26 sheets full of info.

I would like to create a "search box" into which I can enter a word or phrase and then be presented with every FULL ROW from across the entire book that contains that phrase.

Can anyone help?

Thanks,
Ross.

[blobbles]

http://www.cpearson.com/excel/FindAll.aspx is your friend! I got the macros from this site to do the following:

Search Function.xlsm

[Rosscoe28]

Thanks blobbles, I'll give that a shot!