Macro To Separate Data

[Billy Dee]

First post. Hopefully the attachment is enclosed.

I am looking for a macro to separate the data that is seen highlighted in yellow to output in separate columns (output example to the right on yellow). This would be incorporated as a fill all the way down the worksheet until it no longer encounters any more data to the left (thousands of rows).

Thanks.

[Subverter]

This piece of code will do the job (Assuming all the data are organized the same way)..
P.S: i'm not an expert, So.. Forgive me for vague names of variables...

Please Login or Register  to view this content.

And put this function in a module:

Please Login or Register  to view this content.

I wish i had better coding skills.. But -honestly- i did my best...
I hope this will help

[Billy Dee]

Excellent & Perfect. Very well done.

Thanks Subverter.

[Subverter]

You're welcome