find copy and paste contents to another column

[danbob]

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

[JBeaucaire]

Hi danbob, welcome to the forum. Try this macro out:

Please Login or Register  to view this content.

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Edited this time, but read the Rules or you will find questions closed if you don't follow the Rules

[danbob]

Thank you!

The text to column part didn't work quite right so I removed it. Since my report has three tabs to look through, I was able to get it to go through all three tabs. I added it to my macro that I already have for this report and now at month end, an hour and a half worth if work is reduced to 10 minutes!

This forum is Awsome!