Simple macro to search for string

[Timmo246]

Hi guys,

Need a macro to search for a text string in Column A that can be infinitely long. Normally over 100,000 records. String that I'm looking for is unique as it alwasy is preceeded by '<' in the cell.
I would like the maco to search for the string, which looks comonly like '<COM123-1' or '<123'. Create a new worksheet, in the workbook and list all records, but remove the '<' first.

So results would look like
"
Wkb 2
Col A
COM123
COM123-1
123
"
and so on.

Any help would be greatly appreciated.

[dredwolf]

Actually, this is pretty unspecific...are you wanting a new sheet IF the value AFTER the "<" contains "123"? or a new sheet for any 3digit number AFTER the "<" ?
A sample workbook, with some expected output would help I believe

[HSV]

Something like this ?

Please Login or Register  to view this content.

[jraj1106]

Hi.

You try this too:

searchstring.xlsm