VB Code to split data

Hello:

Please refer to attached file.
I have data in sheet1, column A as shown.
I need VB Code to split the data in column A to data as shown in column J thru Q.

Let me know if you have any questions.
Thanks.
Riz

Maybe:

Please Login or Register  to view this content.

Hi John:

Works great.
Would it be possible to write the split data from Column A rather then starting at column J.

Please let me know if you have any questions.
Thanks.

Riz

Try:

Please Login or Register  to view this content.

Hi John:

Thanks a lot..it works great
Riz

You're welcome. Glad to help out and thanks for the feedback. Please mark this thread as SOLVED if you are satisfied with the solution.