ROW A B C D E F------
col
1 CODE CO AC FO CR (-) DR (+) ---
headings
2 1LD M X1 GGG -1000 2000
3 1LD M X1 GGG -2000 4000
4 1LD M X2 SSS -300 500
5 4EN G X2 SSS -4000 8000
6 4EN G X2 SSS -5000 10000
7 4EN S X3 TTT -6000 12000
8 3CO S X3 TTT -7000 14000
9 3CO S X4 SSS -8000 16000
10 3CO S X4 SSS -9000 18000

In Sheet2 I got spreadsheet template setup (see below)

ROW A B C D E
F G----col
1 CR CR CR DR
DR DR---headings 1
2 CO-AC-FO 1LD 3CO 4EN 1LD 3CO
4EN---headings 2

I want macro which should produce result like this in Sheet2 from
Sheet1 (see below). Please if anybody can help


(Shee2)
ROW A B C D
E F G--col
1 CR CR CR DR
DR DR---headings 1
2 CO-AC-FO 1LD 3CO 4EN 1LD 3CO
4EN----headings 2
3 M X1 GGG -3000 6000
4 M X2 SSS -300 500
5 G X2 SSS
-9000 18000
6 S X3 TTT
-6000 2000
7 S X3 TTT -7000
14000
8 S X4 SSS -17000
34000

basically macro should look in Sheet1 Data and then make result like
above