Im very new to VB an i have to do a script that transfers the data of one worksheet to another one.

i have one master file. there the date will be entered manually. looks like this:

location  | Loc1 | Loc2 | Loc3 ...

Value1    | 100   | 150   | 0     .....

Value2    | 99     | 125    | 0     .....

For every month there is a tab created with the same structure.

What i need to do is to update a Worksheet with this data in an other structure.

Should look like this:

Month      | Jän   | Feb | Mar ...

Value1    | 100   | 75    | 2     .....

Value2    | 99     | 10     | 17     .....

and a tab should be created for each location.

Is it possible to do this and how would be a recommended solution?

Thanks very much

Tom