Helpwith Search/Find functions

C

CrowsFox

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top