moizesdarius
New Member
- Joined
- Dec 17, 2018
- Messages
- 1
[TABLE="width: 500"]
<tbody>[TR]
[TD]Doc Date[/TD]
[TD]Amount[/TD]
[TD]Currency[/TD]
[TD]Profit Center[/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="align: right"]11/8/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/8/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/8/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/9/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/9/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/9/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/8/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/8/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/8/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/9/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/9/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/9/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/8/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/8/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/9/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/9/2018[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 132"]
<tbody>[TR]
[TD="align: right"]34,221.57[/TD]
[/TR]
[TR]
[TD="align: right"]14,278.86[/TD]
[/TR]
[TR]
[TD="align: right"]4,330.33[/TD]
[/TR]
[TR]
[TD="align: right"]19,126.05[/TD]
[/TR]
[TR]
[TD="align: right"]13,278.90[/TD]
[/TR]
[TR]
[TD="align: right"]2,668.19[/TD]
[/TR]
[TR]
[TD="align: right"]23,787.76[/TD]
[/TR]
[TR]
[TD="align: right"]9,216.01[/TD]
[/TR]
[TR]
[TD="align: right"]2,635.83[/TD]
[/TR]
[TR]
[TD="align: right"]43,584.87[/TD]
[/TR]
[TR]
[TD="align: right"]4,276.21[/TD]
[/TR]
[TR]
[TD="align: right"]4,982.49[/TD]
[/TR]
[TR]
[TD="align: right"]2,714.65[/TD]
[/TR]
[TR]
[TD="align: right"]355.36[/TD]
[/TR]
[TR]
[TD="align: right"]1,788.60[/TD]
[/TR]
[TR]
[TD="align: right"]610.75[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 39"]
<tbody>[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD]RS00000101[/TD]
[/TR]
[TR]
[TD]RS00000101[/TD]
[/TR]
[TR]
[TD]RS00000101[/TD]
[/TR]
[TR]
[TD]RS00000101[/TD]
[/TR]
[TR]
[TD]RS00000101[/TD]
[/TR]
[TR]
[TD]RS00000101[/TD]
[/TR]
[TR]
[TD]RS00000102[/TD]
[/TR]
[TR]
[TD]RS00000102[/TD]
[/TR]
[TR]
[TD]RS00000102[/TD]
[/TR]
[TR]
[TD]RS00000102[/TD]
[/TR]
[TR]
[TD]RS00000102[/TD]
[/TR]
[TR]
[TD]RS00000102[/TD]
[/TR]
[TR]
[TD]RS00000103[/TD]
[/TR]
[TR]
[TD]RS00000103[/TD]
[/TR]
[TR]
[TD]RS00000103[/TD]
[/TR]
[TR]
[TD]RS00000103[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Could someone give me formula/ VBA code on getting the sums depends if they have the same Profit Center and by
defining the date. Ex. 11/08/2018-11/09/2018 then check if the Profit Center are the same and giving the result of the total amount of each record. Thanks guys
<tbody>[TR]
[TD]Doc Date[/TD]
[TD]Amount[/TD]
[TD]Currency[/TD]
[TD]Profit Center[/TD]
[/TR]
[TR]
[TD][TABLE="width: 75"]
<tbody>[TR]
[TD="align: right"]11/8/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/8/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/8/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/9/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/9/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/9/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/8/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/8/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/8/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/9/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/9/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/9/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/8/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/8/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/9/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/9/2018[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 132"]
<tbody>[TR]
[TD="align: right"]34,221.57[/TD]
[/TR]
[TR]
[TD="align: right"]14,278.86[/TD]
[/TR]
[TR]
[TD="align: right"]4,330.33[/TD]
[/TR]
[TR]
[TD="align: right"]19,126.05[/TD]
[/TR]
[TR]
[TD="align: right"]13,278.90[/TD]
[/TR]
[TR]
[TD="align: right"]2,668.19[/TD]
[/TR]
[TR]
[TD="align: right"]23,787.76[/TD]
[/TR]
[TR]
[TD="align: right"]9,216.01[/TD]
[/TR]
[TR]
[TD="align: right"]2,635.83[/TD]
[/TR]
[TR]
[TD="align: right"]43,584.87[/TD]
[/TR]
[TR]
[TD="align: right"]4,276.21[/TD]
[/TR]
[TR]
[TD="align: right"]4,982.49[/TD]
[/TR]
[TR]
[TD="align: right"]2,714.65[/TD]
[/TR]
[TR]
[TD="align: right"]355.36[/TD]
[/TR]
[TR]
[TD="align: right"]1,788.60[/TD]
[/TR]
[TR]
[TD="align: right"]610.75[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 39"]
<tbody>[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
[TR]
[TD]PHP[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD]RS00000101[/TD]
[/TR]
[TR]
[TD]RS00000101[/TD]
[/TR]
[TR]
[TD]RS00000101[/TD]
[/TR]
[TR]
[TD]RS00000101[/TD]
[/TR]
[TR]
[TD]RS00000101[/TD]
[/TR]
[TR]
[TD]RS00000101[/TD]
[/TR]
[TR]
[TD]RS00000102[/TD]
[/TR]
[TR]
[TD]RS00000102[/TD]
[/TR]
[TR]
[TD]RS00000102[/TD]
[/TR]
[TR]
[TD]RS00000102[/TD]
[/TR]
[TR]
[TD]RS00000102[/TD]
[/TR]
[TR]
[TD]RS00000102[/TD]
[/TR]
[TR]
[TD]RS00000103[/TD]
[/TR]
[TR]
[TD]RS00000103[/TD]
[/TR]
[TR]
[TD]RS00000103[/TD]
[/TR]
[TR]
[TD]RS00000103[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Could someone give me formula/ VBA code on getting the sums depends if they have the same Profit Center and by
defining the date. Ex. 11/08/2018-11/09/2018 then check if the Profit Center are the same and giving the result of the total amount of each record. Thanks guys