This should be an easy macro but after searching for weeks I can't find it. All I want to do is to search column H for specific data and then copy and paste it across to column K and then do a text to column (delimited, comma and space). The lines of data ranges from 25 to over 40,000 (depending on the time of month) and the string of data is not exact for every cell that I need to move.

My thinking is this, find MTB* (it all starts with mtb but the rest is different and I need all cells with mtb), copy, paste over to column K (in the same row) and text to column.

If it finds data beginning with mtb in cell H5 it will copy and paste over to cell K5. Then it continues down until it finds it again in cell H30. The macro continues until it comes to the end of the data.

I've got my macro that takes my text data, parses it out, opens another workbook, does a VLookup, looks for data in a specific column and deletes that line, but for the life of me, I can't figure out this last part.

Any help would be greatly appreciated. Thanks.
Dan