Tough Loop

[neghsmoke]

So i'm almost done with my Macro, but I just can't figure out the final loop to make it work.

My data comes in like such:

6059
0122
1200
4032
6059

6059
6301
6316
6059

All in one column, and one number per row.
The 6059's are always before and after the data that I need, so the loop needs to scroll the entire row and extract the #'s from each row, and use the 6059's like a delimeter. It should fomat the data and move the value to a different row as such (discluding the 6059's), One grouping of #'s per row:
122 1200 4032
6301 6316

Any help?

[neghsmoke]

Oh and for some reason the #'s in this row all come in with a single quote before them, and the only way i've found that I can use .Find is to manually select them all, click the exclamation mark and convert to number. Is there a way to automatically do this in the macro?

[watersev]

hi neghsmoke can you post a sample file with original data and a result you need to obtain?

[Andy Pope]

Something like this, assuming input data in column A and output in column B

Please Login or Register  to view this content.

[neghsmoke]

MacroProject.xlsx
Andy, I will give it a try when I get to work thanks
watersev, attached is the example file

[neghsmoke]

If I'm understanding your code properly, that would return the #'s between the 6059's each on a new row? How would you group each result group in one cell seperated by a space?

[Andy Pope]

Try this mod for your example file and single cell output.

Please Login or Register  to view this content.

[neghsmoke]

Sweet, thanks again Andy

[watersev]

option:

Please Login or Register  to view this content.

[neghsmoke]

Tried Andy's second script today and it worked like a charm. I will try yours out tommorow watersev and try to piece together how it works. Thanks to you both.