Hi all,
I would like to organize data in a workbook which has 2 worksheets, 1st having a list of identifiers in rows, and the other having all the data. The data in the data sheet goes likes this:
Identifier1
Date 1990 1991 1992 1993
Variable1 AAA BBB CCC DDD
Variable2 EEE FFF GGG HHH
Identifier2
Date 1990 1991 1992 1993
Variable1 NA XXX YYY ZZZ
Variable2 ZAA ZBB ZCC ZDD
and so on and so forth.
I would like to output the data such that, there will be a worksheet for every Identifier there is according to the 1st worksheet, and the data from the 2nd worksheet copied to their corresponding named worksheet, and the Data transposed as such:
Identifier1
Date Variable1 Variable2
1990 AAA EEE
1991 BBB FFF
1992 CCC GGG
on 1 worksheet, and the next identifier on another worksheet which is named after the identifier.
Having a few hundred identifiers, it will be great if I can use VBA and learn a thing from you all!
Thanks in advance!
I would like to organize data in a workbook which has 2 worksheets, 1st having a list of identifiers in rows, and the other having all the data. The data in the data sheet goes likes this:
Identifier1
Date 1990 1991 1992 1993
Variable1 AAA BBB CCC DDD
Variable2 EEE FFF GGG HHH
Identifier2
Date 1990 1991 1992 1993
Variable1 NA XXX YYY ZZZ
Variable2 ZAA ZBB ZCC ZDD
and so on and so forth.
I would like to output the data such that, there will be a worksheet for every Identifier there is according to the 1st worksheet, and the data from the 2nd worksheet copied to their corresponding named worksheet, and the Data transposed as such:
Identifier1
Date Variable1 Variable2
1990 AAA EEE
1991 BBB FFF
1992 CCC GGG
on 1 worksheet, and the next identifier on another worksheet which is named after the identifier.
Having a few hundred identifiers, it will be great if I can use VBA and learn a thing from you all!
Thanks in advance!