search and select rows on user entered text

[FoeNyne]

Firstly apologies if this is elsewhere on the site, i did look, i am new to excel and dont really know where to start at all.

What i am looking to do is search using a user input and select all the rows that contain the entered search text.

I have 4 sheet workbook, columns are the same accross them all, and what i require is to be able to take a text input from a user, maybe what column to search, and in what sheet. Then search the relevent sheet for matches. Once found the record that contains the match is to be copied to another sheet where filters can e applied. There will be multiple records selected for each search.

I hope this makes sense.

Any advice or pointers to decent tutorials or templates would be much appreciated.

[VBA Noob]

If you press Ctrl + F to pull up the next box you have the option to search workbook.

But to list the found cells I would suggest installing this useful add-in

http://www.jkp-ads.com/OfficeMarketPlaceFF-EN.asp

Enjoy

VBA Noob

[FoeNyne]

Hi Noob thanks for the interest.

I think I need to explain a bit clearer thou.

I have around 15 columns and a couple of hundred rows. I need the user to enter a string, say for example a street name, and the column it’s expected in. The magic spell is cast and all of the rows that have the entered street name in the specified column are output to a new sheet or the other records are filtered out leaving only the qualifying records.

I have been playing with autofilter’s but there are just too many different values in each column to make this a viable option. I’m guessing some sort of macro or VBA mod.

Hope this is clearer.

[VBA Noob]

Use advance filter

http://www.contextures.com/xladvfilter01.html

Example here

http://www.contextures.com/xladvfilter01.html

VBA Noob

[royUK]

The code that I posted here can easily be adapted to your needs

http://www.excelforum.com/showthread.php?t=629530

I would also think that Advanced Filter would be an option.

[FoeNyne]

Thats the very badboy right there! Cheers Noob.

That’s a bit more elegant and versatile a solution Roy Thanks.

So if I change the last line to rng2.EntireRow.Copy how do I output the copied rows to say a sheet called Results?

[royUK]

Try this

Please Login or Register  to view this content.

[tvravic]

Please try this code with a slight modification of "royUK" code above, which results in "searched" string arranged by "Exact Word" along with "leading" words.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Please Login or Register  to view this content.

[JOHN H. DAVIS]

@ tvravic. Did you notice the thread dates?

[6StringJazzer]

tvravic, please see my note above regarding code tags. Moreover, FoeNyne hasn't posted here for about 6 years so it is unlikely that your contribution will help. I'm not sure what led you to this thread to make your first post but you may want to check dates on threads before spending much effort on them.