Macro to transform raw data into a fixed template

Hi.
I need som desperat help. I have a raw data sheet with 8000 lines times 12 months. I need to convert this data into a fixed template. i have recorded a macro, but I need som help with ajusting the macro so that it takes into consideration the following:
When i filter on company code to only show some data, thats the data I want it to prosess to the other template.
I also need it to loop throug several columns (each column is a month) a copy that data into one column in my template. For each column there are several fixed columns that needs to be copied also and placed in correct columns in my template.

I have also attached a example sheet of the data..

I'm thankfull with any help!

this is my macro:

Please Login or Register  to view this content.

Moderator's Edit: Use code tags when posting code. To do so in future, select your code and click on the # icon at the top of your post window.

Its better if you explain what you are trying to accomplish with the help of your example file. Tell us what data should be copied where and which columns should be copied, etc.

Hi, thank you. I'll trie to explain a bit better. What I want to accomplish is the following:
From the example file column G to R should be copied togehter with column C, E and F. Column G to R shall be posted into column O in my template. Each month after one antoher downwards. Column C from example sheet should be pasted into column N in my template
Column E from example sheet should be copied to column F in my template and column F from example sheet should be pasted into column G in my template.

English is no my native language, so it may be better if I attach the template. From there you'l se what I'm trying to explain. The columns marked red is where I want data pasted from example sheet.