Branch
<tbody>
</tbody>
Excel
tables to the web >> Excel Jeanie
HTML 4
Data
<tbody>
</tbody>
Excel
tables to the web >> Excel Jeanie
HTML 4
I have data in Sheet "Branch" and Sheet "Data" and want to create a new sheet name Sheet "Summary" and include this information into.
Summary
<tbody>
</tbody>
<tbody>
</tbody>
Excel
tables to the web >> Excel Jeanie
HTML 4
Is it can be done in any easy way using macro or any other way?
A | |
1 | Branch |
2 | Branch1 |
3 | Branch2 |
4 | Branch3 |
5 | Branch4 |
6 | Branch5 |
7 | Branch6 |
8 | Branch7 |
9 | Branch8 |
10 | Branch9 |
11 | Branch10 |
12 | Branch11 |
13 | Branch12 |
<tbody>
</tbody>
Excel
tables to the web >> Excel Jeanie
HTML 4
Data
A | B | C | D | E | F | G | |
1 | No. | Dealer | Brand | Qty | Amount | Type | Branch |
2 | 1 | aaa | Alfa Romeo | 2 | 5,000,000.00 | Auto | Branch1 |
3 | 2 | bbb | Alfa Romeo | 3 | 7,000,000.00 | Manual | Branch2 |
4 | 3 | ccc | Alpine | 5 | 10,000,000.00 | Auto | Branch3 |
5 | 4 | aaa | Alpine | 1 | 3,000,000.00 | Auto | Branch4 |
6 | 5 | bbb | Alfa Romeo | 3 | 9,000,000.00 | Auto | Branch5 |
7 | 6 | ccc | Alpine | 2 | 6,000,000.00 | Auto | Branch6 |
8 | 7 | aaa | Audi | 4 | 9,000,000.00 | Auto | Branch7 |
9 | 8 | bbb | Audi | 3 | 8,000,000.00 | Auto | Branch8 |
10 | 9 | ccc | Austin | 2 | 6,000,000.00 | Auto | Branch9 |
11 | 10 | aaa | BMW | 6 | 12,000,000.00 | Manual | Branch10 |
12 | 11 | bbb | Bristol | 3 | 8,000,000.00 | Manual | Branch11 |
13 | 12 | ccc | Bufori | 2 | 8,000,000.00 | Manual | Branch12 |
14 | 13 | aaa | BMW | 1 | 8,000,000.00 | Manual | Branch4 |
15 | 14 | bbb | Bristol | 3 | 8,000,000.00 | Manual | Branch5 |
16 | 15 | ccc | Bufori | 2 | 8,000,000.00 | Manual | Branch6 |
17 | 16 | aaa | Bugatti | 1 | 8,000,000.00 | Auto | Branch7 |
18 | 17 | bbb | Buick | 3 | 8,000,000.00 | Auto | Branch8 |
19 | 18 | ccc | Cadillac | 1 | 8,000,000.00 | Auto | Branch8 |
20 | 19 | aaa | Audi | 3 | 8,000,000.00 | Auto | Branch9 |
21 | 20 | bbb | Austin | 2 | 8,000,000.00 | Auto | Branch10 |
22 | 21 | ccc | Bentley | 5 | 8,000,000.00 | Auto | Branch11 |
23 | 22 | aaa | BMW | 3 | 8,000,000.00 | Auto | Branch12 |
24 | 23 | bbb | Bristol | 2 | 8,000,000.00 | Auto | Branch10 |
25 | 24 | ccc | Bufori | 1 | 8,000,000.00 | Manual | Branch11 |
26 | 25 | aaa | Alfa Romeo | 1 | 8,000,000.00 | Manual | Branch12 |
27 | 26 | bbb | Alpine | 2 | 8,000,000.00 | Auto | Branch4 |
28 | 27 | ccc | Alpine | 3 | 8,000,000.00 | Auto | Branch5 |
29 | 28 | aaa | Audi | 1 | 8,000,000.00 | Auto | Branch6 |
30 | 29 | bbb | Austin | 2 | 8,000,000.00 | Auto | Branch7 |
31 | 30 | ccc | Bentley | 1 | 8,000,000.00 | Auto | Branch12 |
32 | 31 | aaa | BMW | 2 | 8,000,000.00 | Auto | Branch10 |
33 | 32 | bbb | Bristol | 3 | 8,000,000.00 | Auto | Branch11 |
34 | 33 | ccc | Bugatti | 2 | 8,000,000.00 | Auto | Branch12 |
35 | 34 | aaa | Buick | 1 | 8,000,000.00 | Auto | Branch4 |
36 | 35 | bbb | Cadillac | 3 | 8,000,000.00 | Auto | Branch1 |
37 | 36 | ccc | Austin | 2 | 8,000,000.00 | Manual | Branch2 |
38 | 37 | aaa | Bentley | 1 | 8,000,000.00 | Manual | Branch3 |
39 | 38 | bbb | BMW | 1 | 8,000,000.00 | Manual | Branch4 |
40 | 39 | ccc | Bristol | 1 | 8,000,000.00 | Manual | Branch5 |
41 | 40 | aaa | Bufori | 1 | 8,000,000.00 | Manual | Branch11 |
42 | 41 | bbb | Bufori | 2 | 8,000,000.00 | Manual | Branch12 |
43 | 42 | ccc | Alfa Romeo | 3 | 8,000,000.00 | Auto | Branch4 |
44 | 43 | aaa | Audi | 4 | 8,000,000.00 | Auto | Branch1 |
45 | 44 | bbb | Austin | 3 | 8,000,000.00 | Auto | Branch2 |
46 | 45 | ccc | Bentley | 2 | 8,000,000.00 | Auto | Branch3 |
47 | 46 | aaa | BMW | 3 | 8,000,000.00 | Auto | Branch4 |
48 | 47 | bbb | Bristol | 4 | 8,000,000.00 | Auto | Branch5 |
49 | 48 | ccc | Bufori | 2 | 8,000,000.00 | Manual | Branch11 |
50 | 49 | aaa | Bugatti | 1 | 8,000,000.00 | Manual | Branch12 |
51 | 50 | bbb | Buick | 2 | 8,000,000.00 | Manual | Branch4 |
52 | 51 | ccc | Cadillac | 2 | 8,000,000.00 | Manual | Branch5 |
53 | 52 | aaa | Bentley | 1 | 8,000,000.00 | Manual | Branch11 |
54 | 53 | bbb | BMW | 2 | 8,000,000.00 | Auto | Branch12 |
55 | 54 | ccc | Bristol | 1 | 8,000,000.00 | Auto | Branch5 |
56 | 55 | aaa | Bufori | 2 | 8,000,000.00 | Auto | Branch11 |
57 | 56 | bbb | Bugatti | 3 | 8,000,000.00 | Auto | Branch12 |
58 | 57 | ccc | Austin | 2 | 8,000,000.00 | Auto | Branch4 |
59 | 58 | aaa | Bentley | 1 | 8,000,000.00 | Auto | Branch5 |
60 | 59 | bbb | BMW | 1 | 8,000,000.00 | Auto | Branch11 |
61 | 60 | ccc | Bristol | 1 | 8,000,000.00 | Auto | Branch12 |
62 | 61 | aaa | Bufori | 2 | 8,000,000.00 | Manual | Branch5 |
63 | 62 | bbb | Bugatti | 3 | 8,000,000.00 | Manual | Branch11 |
64 | 63 | ccc | Buick | 2 | 8,000,000.00 | Manual | Branch4 |
65 | 64 | aaa | Cadillac | 2 | 8,000,000.00 | Manual | Branch1 |
66 | 65 | bbb | Cadillac | 1 | 8,000,000.00 | Manual | Branch2 |
67 | 66 | ccc | Alfa Romeo | 2 | 8,000,000.00 | Auto | Branch3 |
68 | 67 | aaa | Alpine | 1 | 8,000,000.00 | Auto | Branch4 |
69 | 68 | bbb | Alpine | 2 | 8,000,000.00 | Auto | Branch5 |
70 | 69 | ccc | Audi | 1 | 8,000,000.00 | Auto | Branch4 |
71 | 70 | aaa | Austin | 1 | 8,000,000.00 | Auto | Branch5 |
<tbody>
</tbody>
Excel
tables to the web >> Excel Jeanie
HTML 4
I have data in Sheet "Branch" and Sheet "Data" and want to create a new sheet name Sheet "Summary" and include this information into.
Summary
A | B | C | D | E | F | G | H | I | J | K | L | M | Z | AA | |
5 | Brand | Branch1 | Branch2 | Branch3 | Branch4 | Branch5 | Branch6 | TOTAL | |||||||
6 | Qty | Amount | Qty | Amount | Qty | Amount | Qty | Amount | Qty | Amount | Qty | Amount | Qty | Amount | |
7 | Acura | - | - | - | - | - | - | - | |||||||
8 | Alfa Romeo | 2 | 5,000,000.00 | 3 | 7,000,000.00 | 2 | 8,000,000.00 | 3 | 8,000,000.00 | 3 | 9,000,000.00 | - | 14 | 45,000,000.00 | |
9 | Alpine | - | - | 5 | 10,000,000.00 | 4 | 19,000,000.00 | 5 | 16,000,000.00 | 2 | 6,000,000.00 | 16 | 51,000,000.00 | ||
10 | Aston Martin | - | - | - | - | - | - | - | |||||||
11 | Audi | 4 | 8,000,000.00 | - | - | 1 | 8,000,000.00 | - | 1 | 8,000,000.00 | 16 | 49,000,000.00 | |||
12 | Austin | - | 5 | 16,000,000.00 | - | 2 | 8,000,000.00 | 1 | 8,000,000.00 | - | 14 | 54,000,000.00 | |||
13 | Bentley | - | - | 3 | 16,000,000.00 | - | 1 | 8,000,000.00 | - | 11 | 48,000,000.00 | ||||
14 | BMW | - | - | - | 5 | 24,000,000.00 | - | - | 19 | 68,000,000.00 | |||||
15 | Bristol | - | - | - | - | 9 | 32,000,000.00 | - | 18 | 64,000,000.00 | |||||
16 | Bufori | - | - | - | - | 2 | 8,000,000.00 | 2 | 8,000,000.00 | 14 | 64,000,000.00 | ||||
17 | Bugatti | - | - | - | - | - | - | 10 | 40,000,000.00 | ||||||
18 | Buick | - | - | - | 5 | 24,000,000.00 | - | - | 8 | 32,000,000.00 | |||||
19 | Cadillac | 5 | 16,000,000.00 | 1 | 8,000,000.00 | - | - | 2 | 8,000,000.00 | - | 9 | 40,000,000.00 | |||
20 | TOTAL | 11 | 29,000,000.00 | 9 | 31,000,000.00 | 10 | 34,000,000.00 | 20 | 91,000,000.00 | 23 | 89,000,000.00 | 5 | 22,000,000.00 | 149 | 555,000,000.00 |
21 | |||||||||||||||
22 | Brand | Branch1 | Branch2 | Branch3 | Branch4 | Branch5 | Branch6 | TOTAL | |||||||
23 | Auto | Manual | Auto | Manual | Auto | Manual | Auto | Manual | Auto | Manual | Auto | Manual | Auto | Manual | |
24 | Acura | ||||||||||||||
25 | Alfa Romeo | 1 | 1 | 1 | 1 | 1 | 4 | 2 | |||||||
26 | Alpine | 1 | 3 | 2 | 1 | 7 | |||||||||
27 | Aston Martin | ||||||||||||||
28 | Audi | 1 | 1 | 1 | 6 | ||||||||||
29 | Austin | 1 | 1 | 1 | 1 | 6 | 1 | ||||||||
30 | Bentley | 1 | 1 | 1 | 4 | 2 | |||||||||
31 | BMW | 1 | 2 | 5 | 3 | ||||||||||
32 | Bristol | 2 | 2 | 5 | 3 | ||||||||||
33 | Bufori | 1 | 1 | 1 | 7 | ||||||||||
34 | Bugatti | 3 | 2 | ||||||||||||
35 | Buick | 1 | 2 | 2 | 2 | ||||||||||
36 | Cadillac | 1 | 1 | 1 | 1 | 2 | 3 | ||||||||
37 | TOTAL | 3 | 1 | 1 | 3 | 3 | 1 | 8 | 4 | 7 | 4 | 2 | 1 | 45 | 25 |
<tbody>
</tbody>
Spreadsheet Formulas | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<tbody> </tbody> |
<tbody>
</tbody>
Excel
tables to the web >> Excel Jeanie
HTML 4
Is it can be done in any easy way using macro or any other way?