Searching criteria in excel 2010

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Chrishird

Thread Starter
Joined
Feb 6, 2013
Messages
1
Hello,

This is my first post so go easy on me.

I am a salesman mainly using two suppliers I have both suppliers full price lists (each have approx 9,000 rows) on one work book, but on separate worksheets.

What I am ideally wanting to achieve is to have a search function in another sheet which will then display only the rows with my required search.

Note - The description column has quite a lot of info for eg M8 UNC 5/8 x 50 set screws
I would like to be able to search for example set screws, and then all the set screws from both suppliers to be shown on the new sheet. However I would also like to be able to search for example 5/8 and again for all 5/8 from both suppliers to be shown on the new sheet.

It would be perfect if I could make a search box at the top of the sheet with the results appearing below. I would also need it to renew the results after every search.

Any help much appreciated I have tried things with the find/search function and also the sort containing with function but none work perfectly.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top