Hi! Thanks for taking the time to see if you can help!
My problem is as follows:
I am trying to create a search function.
On sheet 1 I want to place a search box in cell C3.
On sheets 2-20 I have company names listed.
I want to be able to type the company name in a cell on sheet one, and have
it tell me the locations in the workbook that I can find it (it maybe on more
than one sheet)
Much like the "find it" tool. But I need to make it user friendly for the
guys in the office that wont use the "find it tool"..
Thank you so Much!!! (Excel is just way to complicated for me! LOL)