|
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
|