Please ! Help me with Macro Report

M

maigsb

New Member
Joined
Aug 10, 2012
Messages
11
Branch

A

<tbody>
[TD="bgcolor: #CACACA, align: center"]1
[/TD]
[TD="align: center"]Branch
[/TD]

[TD="bgcolor: #CACACA, align: center"]2
[/TD]
[TD="align: center"]Branch1
[/TD]

[TD="bgcolor: #CACACA, align: center"]3
[/TD]
[TD="align: center"]Branch2
[/TD]

[TD="bgcolor: #CACACA, align: center"]4
[/TD]
[TD="align: center"]Branch3
[/TD]

[TD="bgcolor: #CACACA, align: center"]5
[/TD]
[TD="align: center"]Branch4
[/TD]

[TD="bgcolor: #CACACA, align: center"]6
[/TD]
[TD="align: center"]Branch5
[/TD]

[TD="bgcolor: #CACACA, align: center"]7
[/TD]
[TD="align: center"]Branch6
[/TD]

[TD="bgcolor: #CACACA, align: center"]8
[/TD]
[TD="align: center"]Branch7
[/TD]

[TD="bgcolor: #CACACA, align: center"]9
[/TD]
[TD="align: center"]Branch8
[/TD]

[TD="bgcolor: #CACACA, align: center"]10
[/TD]
[TD="align: center"]Branch9
[/TD]

[TD="bgcolor: #CACACA, align: center"]11
[/TD]
[TD="align: center"]Branch10
[/TD]

[TD="bgcolor: #CACACA, align: center"]12
[/TD]
[TD="align: center"]Branch11
[/TD]

[TD="bgcolor: #CACACA, align: center"]13
[/TD]
[TD="align: center"]Branch12
[/TD]

</tbody>


Excel
tables to the web >> Excel Jeanie
HTML 4

Data
A
B
C
D
E
F
G

<tbody>
[TD="bgcolor: #CACACA, align: center"]1
[/TD]
[TD="align: center"]No.
[/TD]
[TD="align: center"]Dealer
[/TD]
[TD="align: center"]Brand
[/TD]
[TD="align: center"]Qty
[/TD]
[TD="align: center"]Amount
[/TD]
[TD="align: center"]Type
[/TD]
[TD="align: center"]Branch
[/TD]

[TD="bgcolor: #CACACA, align: center"]2
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Alfa Romeo
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 5,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch1
[/TD]

[TD="bgcolor: #CACACA, align: center"]3
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Alfa Romeo
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: right"] 7,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch2
[/TD]

[TD="bgcolor: #CACACA, align: center"]4
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Alpine
[/TD]
[TD="align: center"]5
[/TD]
[TD="align: right"] 10,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch3
[/TD]

[TD="bgcolor: #CACACA, align: center"]5
[/TD]
[TD="align: center"]4
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Alpine
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 3,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch4
[/TD]

[TD="bgcolor: #CACACA, align: center"]6
[/TD]
[TD="align: center"]5
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Alfa Romeo
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: right"] 9,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch5
[/TD]

[TD="bgcolor: #CACACA, align: center"]7
[/TD]
[TD="align: center"]6
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Alpine
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 6,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch6
[/TD]

[TD="bgcolor: #CACACA, align: center"]8
[/TD]
[TD="align: center"]7
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Audi
[/TD]
[TD="align: center"]4
[/TD]
[TD="align: right"] 9,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch7
[/TD]

[TD="bgcolor: #CACACA, align: center"]9
[/TD]
[TD="align: center"]8
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Audi
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch8
[/TD]

[TD="bgcolor: #CACACA, align: center"]10
[/TD]
[TD="align: center"]9
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Austin
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 6,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch9
[/TD]

[TD="bgcolor: #CACACA, align: center"]11
[/TD]
[TD="align: center"]10
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]BMW
[/TD]
[TD="align: center"]6
[/TD]
[TD="align: right"] 12,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch10
[/TD]

[TD="bgcolor: #CACACA, align: center"]12
[/TD]
[TD="align: center"]11
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Bristol
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch11
[/TD]

[TD="bgcolor: #CACACA, align: center"]13
[/TD]
[TD="align: center"]12
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Bufori
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch12
[/TD]

[TD="bgcolor: #CACACA, align: center"]14
[/TD]
[TD="align: center"]13
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]BMW
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch4
[/TD]

[TD="bgcolor: #CACACA, align: center"]15
[/TD]
[TD="align: center"]14
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Bristol
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch5
[/TD]

[TD="bgcolor: #CACACA, align: center"]16
[/TD]
[TD="align: center"]15
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Bufori
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch6
[/TD]

[TD="bgcolor: #CACACA, align: center"]17
[/TD]
[TD="align: center"]16
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Bugatti
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch7
[/TD]

[TD="bgcolor: #CACACA, align: center"]18
[/TD]
[TD="align: center"]17
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Buick
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch8
[/TD]

[TD="bgcolor: #CACACA, align: center"]19
[/TD]
[TD="align: center"]18
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Cadillac
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch8
[/TD]

[TD="bgcolor: #CACACA, align: center"]20
[/TD]
[TD="align: center"]19
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Audi
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch9
[/TD]

[TD="bgcolor: #CACACA, align: center"]21
[/TD]
[TD="align: center"]20
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Austin
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch10
[/TD]

[TD="bgcolor: #CACACA, align: center"]22
[/TD]
[TD="align: center"]21
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Bentley
[/TD]
[TD="align: center"]5
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch11
[/TD]

[TD="bgcolor: #CACACA, align: center"]23
[/TD]
[TD="align: center"]22
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]BMW
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch12
[/TD]

[TD="bgcolor: #CACACA, align: center"]24
[/TD]
[TD="align: center"]23
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Bristol
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch10
[/TD]

[TD="bgcolor: #CACACA, align: center"]25
[/TD]
[TD="align: center"]24
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Bufori
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch11
[/TD]

[TD="bgcolor: #CACACA, align: center"]26
[/TD]
[TD="align: center"]25
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Alfa Romeo
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch12
[/TD]

[TD="bgcolor: #CACACA, align: center"]27
[/TD]
[TD="align: center"]26
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Alpine
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch4
[/TD]

[TD="bgcolor: #CACACA, align: center"]28
[/TD]
[TD="align: center"]27
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Alpine
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch5
[/TD]

[TD="bgcolor: #CACACA, align: center"]29
[/TD]
[TD="align: center"]28
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Audi
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch6
[/TD]

[TD="bgcolor: #CACACA, align: center"]30
[/TD]
[TD="align: center"]29
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Austin
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch7
[/TD]

[TD="bgcolor: #CACACA, align: center"]31
[/TD]
[TD="align: center"]30
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Bentley
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch12
[/TD]

[TD="bgcolor: #CACACA, align: center"]32
[/TD]
[TD="align: center"]31
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]BMW
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch10
[/TD]

[TD="bgcolor: #CACACA, align: center"]33
[/TD]
[TD="align: center"]32
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Bristol
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch11
[/TD]

[TD="bgcolor: #CACACA, align: center"]34
[/TD]
[TD="align: center"]33
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Bugatti
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch12
[/TD]

[TD="bgcolor: #CACACA, align: center"]35
[/TD]
[TD="align: center"]34
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Buick
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch4
[/TD]

[TD="bgcolor: #CACACA, align: center"]36
[/TD]
[TD="align: center"]35
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Cadillac
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch1
[/TD]

[TD="bgcolor: #CACACA, align: center"]37
[/TD]
[TD="align: center"]36
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Austin
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch2
[/TD]

[TD="bgcolor: #CACACA, align: center"]38
[/TD]
[TD="align: center"]37
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Bentley
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch3
[/TD]

[TD="bgcolor: #CACACA, align: center"]39
[/TD]
[TD="align: center"]38
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]BMW
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch4
[/TD]

[TD="bgcolor: #CACACA, align: center"]40
[/TD]
[TD="align: center"]39
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Bristol
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch5
[/TD]

[TD="bgcolor: #CACACA, align: center"]41
[/TD]
[TD="align: center"]40
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Bufori
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch11
[/TD]

[TD="bgcolor: #CACACA, align: center"]42
[/TD]
[TD="align: center"]41
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Bufori
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch12
[/TD]

[TD="bgcolor: #CACACA, align: center"]43
[/TD]
[TD="align: center"]42
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Alfa Romeo
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch4
[/TD]

[TD="bgcolor: #CACACA, align: center"]44
[/TD]
[TD="align: center"]43
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Audi
[/TD]
[TD="align: center"]4
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch1
[/TD]

[TD="bgcolor: #CACACA, align: center"]45
[/TD]
[TD="align: center"]44
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Austin
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch2
[/TD]

[TD="bgcolor: #CACACA, align: center"]46
[/TD]
[TD="align: center"]45
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Bentley
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch3
[/TD]

[TD="bgcolor: #CACACA, align: center"]47
[/TD]
[TD="align: center"]46
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]BMW
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch4
[/TD]

[TD="bgcolor: #CACACA, align: center"]48
[/TD]
[TD="align: center"]47
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Bristol
[/TD]
[TD="align: center"]4
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch5
[/TD]

[TD="bgcolor: #CACACA, align: center"]49
[/TD]
[TD="align: center"]48
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Bufori
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch11
[/TD]

[TD="bgcolor: #CACACA, align: center"]50
[/TD]
[TD="align: center"]49
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Bugatti
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch12
[/TD]

[TD="bgcolor: #CACACA, align: center"]51
[/TD]
[TD="align: center"]50
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Buick
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch4
[/TD]

[TD="bgcolor: #CACACA, align: center"]52
[/TD]
[TD="align: center"]51
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Cadillac
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch5
[/TD]

[TD="bgcolor: #CACACA, align: center"]53
[/TD]
[TD="align: center"]52
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Bentley
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch11
[/TD]

[TD="bgcolor: #CACACA, align: center"]54
[/TD]
[TD="align: center"]53
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]BMW
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch12
[/TD]

[TD="bgcolor: #CACACA, align: center"]55
[/TD]
[TD="align: center"]54
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Bristol
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch5
[/TD]

[TD="bgcolor: #CACACA, align: center"]56
[/TD]
[TD="align: center"]55
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Bufori
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch11
[/TD]

[TD="bgcolor: #CACACA, align: center"]57
[/TD]
[TD="align: center"]56
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Bugatti
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch12
[/TD]

[TD="bgcolor: #CACACA, align: center"]58
[/TD]
[TD="align: center"]57
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Austin
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch4
[/TD]

[TD="bgcolor: #CACACA, align: center"]59
[/TD]
[TD="align: center"]58
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Bentley
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch5
[/TD]

[TD="bgcolor: #CACACA, align: center"]60
[/TD]
[TD="align: center"]59
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]BMW
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch11
[/TD]

[TD="bgcolor: #CACACA, align: center"]61
[/TD]
[TD="align: center"]60
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Bristol
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch12
[/TD]

[TD="bgcolor: #CACACA, align: center"]62
[/TD]
[TD="align: center"]61
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Bufori
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch5
[/TD]

[TD="bgcolor: #CACACA, align: center"]63
[/TD]
[TD="align: center"]62
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Bugatti
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch11
[/TD]

[TD="bgcolor: #CACACA, align: center"]64
[/TD]
[TD="align: center"]63
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Buick
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch4
[/TD]

[TD="bgcolor: #CACACA, align: center"]65
[/TD]
[TD="align: center"]64
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Cadillac
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch1
[/TD]

[TD="bgcolor: #CACACA, align: center"]66
[/TD]
[TD="align: center"]65
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Cadillac
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Branch2
[/TD]

[TD="bgcolor: #CACACA, align: center"]67
[/TD]
[TD="align: center"]66
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Alfa Romeo
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch3
[/TD]

[TD="bgcolor: #CACACA, align: center"]68
[/TD]
[TD="align: center"]67
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Alpine
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch4
[/TD]

[TD="bgcolor: #CACACA, align: center"]69
[/TD]
[TD="align: center"]68
[/TD]
[TD="align: center"]bbb
[/TD]
[TD="align: center"]Alpine
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch5
[/TD]

[TD="bgcolor: #CACACA, align: center"]70
[/TD]
[TD="align: center"]69
[/TD]
[TD="align: center"]ccc
[/TD]
[TD="align: center"]Audi
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch4
[/TD]

[TD="bgcolor: #CACACA, align: center"]71
[/TD]
[TD="align: center"]70
[/TD]
[TD="align: center"]aaa
[/TD]
[TD="align: center"]Austin
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Branch5
[/TD]

</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
Acura
Alfa Romeo
Alpine
Aston Martin
Audi
Austin
Bentley
BMW
Bristol
Bufori
Bugatti
Buick
Cadillac
Acura
Alfa Romeo
Alpine
Aston Martin
Audi
Austin
Bentley
BMW
Bristol
Bufori
Bugatti
Buick
Cadillac

<tbody>
[TD="bgcolor: #CACACA, align: center"]5
[/TD]
[TD="align: center"]Brand
[/TD]
[TD="colspan: 2, align: center"]Branch1
[/TD]
[TD="colspan: 2, align: center"]Branch2
[/TD]
[TD="colspan: 2, align: center"]Branch3
[/TD]
[TD="colspan: 2, align: center"]Branch4
[/TD]
[TD="colspan: 2, align: center"]Branch5
[/TD]
[TD="colspan: 2, align: center"]Branch6
[/TD]
[TD="colspan: 2, align: center"]TOTAL
[/TD]

[TD="bgcolor: #CACACA, align: center"]6
[/TD]
[TD="align: center"]Qty
[/TD]
[TD="align: center"]Amount
[/TD]
[TD="align: center"]Qty
[/TD]
[TD="align: center"]Amount
[/TD]
[TD="align: center"]Qty
[/TD]
[TD="align: center"]Amount
[/TD]
[TD="align: center"]Qty
[/TD]
[TD="align: center"]Amount
[/TD]
[TD="align: center"]Qty
[/TD]
[TD="align: center"]Amount
[/TD]
[TD="align: center"]Qty
[/TD]
[TD="align: center"]Amount
[/TD]
[TD="align: center"]Qty
[/TD]
[TD="align: center"]Amount
[/TD]

[TD="bgcolor: #CACACA, align: center"]7
[/TD]

[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]

[TD="bgcolor: #CACACA, align: center"]8
[/TD]

[TD="align: center"]2
[/TD]
[TD="align: center"] 5,000,000.00
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: center"] 7,000,000.00
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: center"] 8,000,000.00
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: center"] 8,000,000.00
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: center"] 9,000,000.00
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]14
[/TD]
[TD="align: center"] 45,000,000.00
[/TD]

[TD="bgcolor: #CACACA, align: center"]9
[/TD]

[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]5
[/TD]
[TD="align: center"]10,000,000.00
[/TD]
[TD="align: center"]4
[/TD]
[TD="align: center"]19,000,000.00
[/TD]
[TD="align: center"]5
[/TD]
[TD="align: center"]16,000,000.00
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: center"] 6,000,000.00
[/TD]
[TD="align: center"]16
[/TD]
[TD="align: center"] 51,000,000.00
[/TD]

[TD="bgcolor: #CACACA, align: center"]10
[/TD]

[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]

[TD="bgcolor: #CACACA, align: center"]11
[/TD]

[TD="align: center"]4
[/TD]
[TD="align: center"] 8,000,000.00
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"] 8,000,000.00
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"] 8,000,000.00
[/TD]
[TD="align: center"]16
[/TD]
[TD="align: center"] 49,000,000.00
[/TD]

[TD="bgcolor: #CACACA, align: center"]12
[/TD]

[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]5
[/TD]
[TD="align: center"]16,000,000.00
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: center"] 8,000,000.00
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"] 8,000,000.00
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]14
[/TD]
[TD="align: center"] 54,000,000.00
[/TD]

[TD="bgcolor: #CACACA, align: center"]13
[/TD]

[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: center"]16,000,000.00
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"] 8,000,000.00
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]11
[/TD]
[TD="align: center"] 48,000,000.00
[/TD]

[TD="bgcolor: #CACACA, align: center"]14
[/TD]

[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]5
[/TD]
[TD="align: center"]24,000,000.00
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]19
[/TD]
[TD="align: center"] 68,000,000.00
[/TD]

[TD="bgcolor: #CACACA, align: center"]15
[/TD]

[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]9
[/TD]
[TD="align: center"]32,000,000.00
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]18
[/TD]
[TD="align: center"] 64,000,000.00
[/TD]

[TD="bgcolor: #CACACA, align: center"]16
[/TD]

[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: center"] 8,000,000.00
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: right"] 8,000,000.00
[/TD]
[TD="align: center"]14
[/TD]
[TD="align: center"] 64,000,000.00
[/TD]

[TD="bgcolor: #CACACA, align: center"]17
[/TD]

[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]10
[/TD]
[TD="align: center"] 40,000,000.00
[/TD]

[TD="bgcolor: #CACACA, align: center"]18
[/TD]

[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]5
[/TD]
[TD="align: center"]24,000,000.00
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]8
[/TD]
[TD="align: center"] 32,000,000.00
[/TD]

[TD="bgcolor: #CACACA, align: center"]19
[/TD]

[TD="align: center"]5
[/TD]
[TD="align: center"]16,000,000.00
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"] 8,000,000.00
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: center"] 8,000,000.00
[/TD]
[TD="align: center"][/TD]
[TD="align: center"] -
[/TD]
[TD="align: center"]9
[/TD]
[TD="align: center"] 40,000,000.00
[/TD]

[TD="bgcolor: #CACACA, align: center"]20
[/TD]
[TD="align: center"]TOTAL
[/TD]
[TD="align: center"]11
[/TD]
[TD="align: center"]29,000,000.00
[/TD]
[TD="align: center"]9
[/TD]
[TD="align: center"]31,000,000.00
[/TD]
[TD="align: center"]10
[/TD]
[TD="align: center"]34,000,000.00
[/TD]
[TD="align: center"]20
[/TD]
[TD="align: center"]91,000,000.00
[/TD]
[TD="align: center"]23
[/TD]
[TD="align: center"]89,000,000.00
[/TD]
[TD="align: center"]5
[/TD]
[TD="align: center"]22,000,000.00
[/TD]
[TD="align: center"]149
[/TD]
[TD="align: center"]555,000,000.00
[/TD]

[TD="bgcolor: #CACACA, align: center"]21
[/TD]

[TD="bgcolor: #CACACA, align: center"]22
[/TD]
[TD="align: center"]Brand
[/TD]
[TD="colspan: 2, align: center"]Branch1
[/TD]
[TD="colspan: 2, align: center"]Branch2
[/TD]
[TD="colspan: 2, align: center"]Branch3
[/TD]
[TD="colspan: 2, align: center"]Branch4
[/TD]
[TD="colspan: 2, align: center"]Branch5
[/TD]
[TD="colspan: 2, align: center"]Branch6
[/TD]
[TD="colspan: 2, align: center"]TOTAL
[/TD]

[TD="bgcolor: #CACACA, align: center"]23
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Manual
[/TD]
[TD="align: center"]Auto
[/TD]
[TD="align: center"]Manual
[/TD]

[TD="bgcolor: #CACACA, align: center"]24
[/TD]

[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="bgcolor: #CACACA, align: center"]25
[/TD]

[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]4
[/TD]
[TD="align: center"]2
[/TD]

[TD="bgcolor: #CACACA, align: center"]26
[/TD]

[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]3
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]7
[/TD]
[TD="align: center"][/TD]

[TD="bgcolor: #CACACA, align: center"]27
[/TD]

[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="bgcolor: #CACACA, align: center"]28
[/TD]

[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]6
[/TD]
[TD="align: center"][/TD]

[TD="bgcolor: #CACACA, align: center"]29
[/TD]

[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]6
[/TD]
[TD="align: center"]1
[/TD]

[TD="bgcolor: #CACACA, align: center"]30
[/TD]

[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]4
[/TD]
[TD="align: center"]2
[/TD]

[TD="bgcolor: #CACACA, align: center"]31
[/TD]

[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]5
[/TD]
[TD="align: center"]3
[/TD]

[TD="bgcolor: #CACACA, align: center"]32
[/TD]

[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]5
[/TD]
[TD="align: center"]3
[/TD]

[TD="bgcolor: #CACACA, align: center"]33
[/TD]

[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]7
[/TD]

[TD="bgcolor: #CACACA, align: center"]34
[/TD]

[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]3
[/TD]
[TD="align: center"]2
[/TD]

[TD="bgcolor: #CACACA, align: center"]35
[/TD]

[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2
[/TD]
[TD="align: center"]2
[/TD]

[TD="bgcolor: #CACACA, align: center"]36
[/TD]

[TD="align: center"]1
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2
[/TD]
[TD="align: center"]3
[/TD]

[TD="bgcolor: #CACACA, align: center"]37
[/TD]
[TD="align: center"]TOTAL
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]8
[/TD]
[TD="align: center"]4
[/TD]
[TD="align: center"]7
[/TD]
[TD="align: center"]4
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]45
[/TD]
[TD="align: center"]25
[/TD]

</tbody>


Spreadsheet Formulas

Cell
Formula
Z7
=SUM(B7,D7,F7,H7,J7,L7,N7,P7,R7,T7,V7,X7)
AA7
=SUM(C7,E7,G7,I7,K7,M7,O7,Q7,S7,U7,W7,Y7)
Z8
=SUM(B8,D8,F8,H8,J8,L8,N8,P8,R8,T8,V8,X8)
AA8
=SUM(C8,E8,G8,I8,K8,M8,O8,Q8,S8,U8,W8,Y8)
Z9
=SUM(B9,D9,F9,H9,J9,L9,N9,P9,R9,T9,V9,X9)
AA9
=SUM(C9,E9,G9,I9,K9,M9,O9,Q9,S9,U9,W9,Y9)
Z10
=SUM(B10,D10,F10,H10,J10,L10,N10,P10,R10,T10,V10,X10)
AA10
=SUM(C10,E10,G10,I10,K10,M10,O10,Q10,S10,U10,W10,Y10)
Z11
=SUM(B11,D11,F11,H11,J11,L11,N11,P11,R11,T11,V11,X11)
AA11
=SUM(C11,E11,G11,I11,K11,M11,O11,Q11,S11,U11,W11,Y11)
Z12
=SUM(B12,D12,F12,H12,J12,L12,N12,P12,R12,T12,V12,X12)
AA12
=SUM(C12,E12,G12,I12,K12,M12,O12,Q12,S12,U12,W12,Y12)
Z13
=SUM(B13,D13,F13,H13,J13,L13,N13,P13,R13,T13,V13,X13)
AA13
=SUM(C13,E13,G13,I13,K13,M13,O13,Q13,S13,U13,W13,Y13)
Z14
=SUM(B14,D14,F14,H14,J14,L14,N14,P14,R14,T14,V14,X14)
AA14
=SUM(C14,E14,G14,I14,K14,M14,O14,Q14,S14,U14,W14,Y14)
Z15
=SUM(B15,D15,F15,H15,J15,L15,N15,P15,R15,T15,V15,X15)
AA15
=SUM(C15,E15,G15,I15,K15,M15,O15,Q15,S15,U15,W15,Y15)
Z16
=SUM(B16,D16,F16,H16,J16,L16,N16,P16,R16,T16,V16,X16)
AA16
=SUM(C16,E16,G16,I16,K16,M16,O16,Q16,S16,U16,W16,Y16)
Z17
=SUM(B17,D17,F17,H17,J17,L17,N17,P17,R17,T17,V17,X17)
AA17
=SUM(C17,E17,G17,I17,K17,M17,O17,Q17,S17,U17,W17,Y17)
Z18
=SUM(B18,D18,F18,H18,J18,L18,N18,P18,R18,T18,V18,X18)
AA18
=SUM(C18,E18,G18,I18,K18,M18,O18,Q18,S18,U18,W18,Y18)
Z19
=SUM(B19,D19,F19,H19,J19,L19,N19,P19,R19,T19,V19,X19)
AA19
=SUM(C19,E19,G19,I19,K19,M19,O19,Q19,S19,U19,W19,Y19)
B20
=SUM(B7:B19)
C20
=SUM(C7:C19)
D20
=SUM(D7:D19)
E20
=SUM(E7:E19)
F20
=SUM(F7:F19)
G20
=SUM(G7:G19)
H20
=SUM(H7:H19)
I20
=SUM(I7:I19)
J20
=SUM(J7:J19)
K20
=SUM(K7:K19)
L20
=SUM(L7:L19)
M20
=SUM(M7:M19)
Z20
=SUM(B20,D20,F20,H20,J20,L20,N20,P20,R20,T20,V20,X20)
AA20
=SUM(C20,E20,G20,I20,K20,M20,O20,Q20,S20,U20,W20,Y20)
Z24
=SUM(B24,D24,F24,H24,J24,L24,N24,P24,R24,T24,V24,X24)
AA24
=SUM(C24,E24,G24,I24,K24,M24,O24,Q24,S24,U24,W24,Y24)
Z25
=SUM(B25,D25,F25,H25,J25,L25,N25,P25,R25,T25,V25,X25)
AA25
=SUM(C25,E25,G25,I25,K25,M25,O25,Q25,S25,U25,W25,Y25)
Z26
=SUM(B26,D26,F26,H26,J26,L26,N26,P26,R26,T26,V26,X26)
AA26
=SUM(C26,E26,G26,I26,K26,M26,O26,Q26,S26,U26,W26,Y26)
Z27
=SUM(B27,D27,F27,H27,J27,L27,N27,P27,R27,T27,V27,X27)
AA27
=SUM(C27,E27,G27,I27,K27,M27,O27,Q27,S27,U27,W27,Y27)
Z28
=SUM(B28,D28,F28,H28,J28,L28,N28,P28,R28,T28,V28,X28)
AA28
=SUM(C28,E28,G28,I28,K28,M28,O28,Q28,S28,U28,W28,Y28)
Z29
=SUM(B29,D29,F29,H29,J29,L29,N29,P29,R29,T29,V29,X29)
AA29
=SUM(C29,E29,G29,I29,K29,M29,O29,Q29,S29,U29,W29,Y29)
Z30
=SUM(B30,D30,F30,H30,J30,L30,N30,P30,R30,T30,V30,X30)
AA30
=SUM(C30,E30,G30,I30,K30,M30,O30,Q30,S30,U30,W30,Y30)
Z31
=SUM(B31,D31,F31,H31,J31,L31,N31,P31,R31,T31,V31,X31)
AA31
=SUM(C31,E31,G31,I31,K31,M31,O31,Q31,S31,U31,W31,Y31)
Z32
=SUM(B32,D32,F32,H32,J32,L32,N32,P32,R32,T32,V32,X32)
AA32
=SUM(C32,E32,G32,I32,K32,M32,O32,Q32,S32,U32,W32,Y32)
Z33
=SUM(B33,D33,F33,H33,J33,L33,N33,P33,R33,T33,V33,X33)
AA33
=SUM(C33,E33,G33,I33,K33,M33,O33,Q33,S33,U33,W33,Y33)
Z34
=SUM(B34,D34,F34,H34,J34,L34,N34,P34,R34,T34,V34,X34)
AA34
=SUM(C34,E34,G34,I34,K34,M34,O34,Q34,S34,U34,W34,Y34)
Z35
=SUM(B35,D35,F35,H35,J35,L35,N35,P35,R35,T35,V35,X35)
AA35
=SUM(C35,E35,G35,I35,K35,M35,O35,Q35,S35,U35,W35,Y35)
Z36
=SUM(B36,D36,F36,H36,J36,L36,N36,P36,R36,T36,V36,X36)
AA36
=SUM(C36,E36,G36,I36,K36,M36,O36,Q36,S36,U36,W36,Y36)
B37
=SUM(B24:B36)
C37
=SUM(C24:C36)
D37
=SUM(D24:D36)
E37
=SUM(E24:E36)
F37
=SUM(F25:F36)
G37
=SUM(G25:G36)
H37
=SUM(H24:H36)
I37
=SUM(I24:I36)
J37
=SUM(J25:J36)
K37
=SUM(K25:K36)
L37
=SUM(L24:L36)
M37
=SUM(M24:M36)
Z37
=SUM(B37,D37,F37,H37,J37,L37,N37,P37,R37,T37,V37,X37)
AA37
=SUM(C37,E37,G37,I37,K37,M37,O37,Q37,S37,U37,W37,Y37)

<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?
 
Sort by date Sort by votes
maigsb,

There must be something different in your first three posted screenshots of worksheets Branch, Data, and Summary.

My posted screenshots look like yours for worksheets Branch, Data, and Summary.

The screenshots (yours and mine) for worksheets Summary, columns A, B, C, are identical.


The only way to resolve this is for you to attach a link to your workbook on Box.com, containing worksheets Branch, Data, and Summary.


You can upload your workbook to Box Net,

sensitive data scrubbed/removed/changed

mark the workbook for sharing
and provide us with a link to your workbook.
 
Upvote 0

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
maigsb,


The macro did not work correctly in your workbook, because, the following bold unique car names in worksheet Data contain a trailing space character, and so do those in your other table:


Excel Workbook
IJK
1Brand
2
3???????????
4Alfa RomeoAlfa Romeo
5AlpineAlpine
6AudiAudi
7AustinAustin
8BentleyBentley
9BMWBMW
10BristolBristol
11BuforiBufori
12BugattiBugatti
13BuickBuick
14CadillacCadillac
Data






My macro code contains a vehicle array, that includes the two additional cars per your post:

Code: 
v = Array("Acura", "Alfa Romeo", "Alpine", "Aston Martin", "Audi", "Austin", "Bentley", "BMW", "Bristol", "Bufori", "Bugatti", "Buick", "Cadillac")


I can adjust the vehicle array to contain the extra trailing space characters for the vehicles mentioned?????
 
Upvote 0
maigsb,

You are very welcome. Glad I could help.

Thanks for the feedback.

Come back anytime.
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Solved
Populate verbatim with criteria
Replies
7
Views
265
Fluff
Fluff
B
  • Question Question
VLOOKUP or INDEX/MATCH Result Skips Blanks Help
Replies
5
Views
919
Aladin Akyurek
Aladin Akyurek
vds1
  • Question Question
Please help me designing query
Replies
8
Views
578
vds1
vds1
A
  • Question Question
Conditional sum help?
Replies
5
Views
5K
stanleydgromjr
S
N
  • Question Question
Advanced Filter, xlFilterCopy and macro help
Replies
3
Views
2K
n0esc
N

Forum statistics

Threads
1,223,912
Messages
6,175,339
Members
452,637
Latest member
Ezio2866

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top