Macro for Partial String in Text

[kclong]

I want to write an macro where it searches for text in a column, but the text may be a partial string. The text is in column B, with account numbers in column A, like this:

Column A Column B
1100 Jay
1101 Jack
1102 Jackson
1103 Jacksony
1104 Jefferson

For example, I want to search on Jack in column B. In the above example, I want it to find accounts 1101, 1102, and 1103, and to copy that information to another spreadsheet, say, sheet2. If possible, I'd like it to copy the first account number and name, 1101 Jack, and if that's not what the user wants, they click next and they see 102 Jackson and so forth. Any help you can give me is greatly apprecited.

 

[ksidersky]

Would anyone be able to help me, (I am pretty desperate) with a search macro (excel 2007/2010) that works very similar to Ctr F / Edit Find, except that I would like to be able to search for a partial text string / value (numbers) for example.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I have various models of cars with different model numbers eg.<o></o>
<o></o>
BMW 320<o></o>
BMW 320i<o></o>
BMW 750<o></o>
<o></o>
When the macro is run I would like a search box to appear and allow the user to input different variations, key words eg in the search box I would enter "320 bm" and the result should return all the above entries because each of the entries contain “bm” and two contain “bm and 320”. This would work the same as ctrl find until it can find no more entries.<o></o>
<o></o>
The data could be across various worksheets is one workbook and the search must not be case sensitive

Thanking you in advance

Kevin

 

[VoG]

Try creating your own thread. Not many helpers will look at an old thread with lots of replies.

 

[ksidersky]

I am extremely inexperienced with using Macro's and would be most grateful if you could assist me with the correct thread so that I can hopefully try and understand and learn how the process work<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[VoG]

Exit this thread. Near the top of the page click on New Thread.