Multiple search... copy then paste on new worksheet

[Yorkie]

Hi!
I know how to do a crude search in worksheets, but it is a singular search and goes to each cell until I click on the input box that it is a match.

I need one that will find all possible matches then copy all of these and paste them on a new worksheet (or existing one) so that I can see the possibilites. OR all the matches are shown on a message box.

Can any one help??

Y

 

[Egress1]

Hi!
I know how to do a crude search in worksheets, but it is a singular search and goes to each cell until I click on the input box that it is a match.

I need one that will find all possible matches then copy all of these and paste them on a new worksheet (or existing one) so that I can see the possibilites. OR all the matches are shown on a message box.

Can any one help??

Y

Have you tried using the AUTO FILTER function?

 

[Yorkie]

Thanks.

Is there a way to link an input box to any of the Autofilters?

i.e. you type in what your looking for and it searches every column and does the auto filter for you.

Also is there a way of moving input and message boxes from popping up in the middle of the screen?

Any suggestions will be welcomed greatly.

Y

 

[Egress1]

I'm still not clear on what exactly it is you're wanting to do. Are you looking for all EXACT matches or are we talking about partial matches and wildcard searches can you give me an example of something you might search and an example of the data your looking at?