JakariKryze
New Member
- Joined
- Dec 14, 2021
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
I have data in one sheet that i am manipulating and i need to sum all the totals of items of the same type together on a summary page. i am still new to VBA and so i dont have a code to start out with.
This is the Blackboard Sheet and the one below it is the Summary sheet. I need to sum all the totals of the same type and have it appear in the summary page in the second column. thanks for your help.
This is the Blackboard Sheet and the one below it is the Summary sheet. I need to sum all the totals of the same type and have it appear in the summary page in the second column. thanks for your help.
Retail Tran Date | Product Department Name | Sum of Product Net Sales Amt | Sum of Product Tax Amount | Sales Total |
12/8/2021 0:00 | ACF - Bulk - Tax | $14.25 | $1.14 | $15.39 |
12/3/2021 0:00 | ACF - Drinks - Tax | $18.00 | $1.27 | $19.27 |
12/8/2021 0:00 | ACF - Drinks - Tax | $13.50 | $1.04 | $14.54 |
12/7/2021 0:00 | ACF - Drinks - Tax | $8.10 | $0.57 | $8.67 |
12/2/2021 0:00 | ACF - Drinks - Tax | $11.70 | $0.90 | $12.60 |
12/10/2021 0:00 | ACF - Drinks - Tax | $44.70 | $3.27 | $47.97 |
12/6/2021 0:00 | ACF - Drinks - Tax | $31.50 | $2.36 | $33.86 |
12/9/2021 0:00 | ACF - Drinks - Tax | $60.30 | $4.27 | $64.57 |
12/2/2021 0:00 | ACF - Gift Boxes - No Tax | $38.85 | $0.00 | $38.85 |
12/1/2021 0:00 | ACF - Gift Boxes - No Tax | $50.00 | $0.00 | $50.00 |
12/6/2021 0:00 | ACF - Gift Boxes - Tax | $59.95 | $4.20 | $64.15 |
12/8/2021 0:00 | ACF - Gift Boxes - Tax | $39.90 | $0.00 | $39.90 |
12/3/2021 0:00 | ACF - Gift Boxes - Tax | $19.95 | $1.40 | $21.35 |
12/10/2021 0:00 | ACF - Gift Boxes - Tax | $99.95 | $7.00 | $106.95 |
12/9/2021 0:00 | ACF - Gift Boxes - Tax | $29.95 | $2.10 | $32.05 |
12/8/2021 0:00 | ACF - Misc - No Tax | $461.54 | $0.00 | $461.54 |
12/1/2021 0:00 | ACF - Misc - No Tax | $248.65 | $0.00 | $248.65 |
12/2/2021 0:00 | ACF - Misc - No Tax | $150.00 | $0.00 | $150.00 |
12/9/2021 0:00 | ACF - Misc - No Tax | $825.72 | $0.00 | $825.72 |
12/7/2021 0:00 | ACF - Misc - No Tax | $2,597.60 | $0.00 | $2,597.60 |
12/10/2021 0:00 | ACF - Misc - No Tax | $192.27 | $0.00 | $192.27 |
12/3/2021 0:00 | ACF - Misc - No Tax | $127.25 | $0.00 | $127.25 |
12/2/2021 0:00 | ACF - Misc - Tax | $2,886.36 | $202.06 | $3,088.42 |
12/10/2021 0:00 | ACF - Misc - Tax | $171.19 | $11.96 | $183.15 |
12/7/2021 0:00 | ACF - Misc - Tax | $42.16 | $2.38 | $44.54 |
12/9/2021 0:00 | ACF - Misc - Tax | $255.02 | $17.91 | $272.93 |
12/3/2021 0:00 | ACF - Misc - Tax | $226.78 | $16.36 | $243.14 |
12/6/2021 0:00 | ACF - Misc - Tax | $137.80 | $10.21 | $148.01 |
12/8/2021 0:00 | ACF - Misc - Tax | $149.83 | $10.91 | $160.74 |
12/1/2021 0:00 | ACF - Misc - Tax | $272.35 | $19.84 | $292.19 |
12/9/2021 0:00 | ACF - Mixes | $59.85 | $4.19 | $64.04 |
12/1/2021 0:00 | ACF - Mixes | $28.80 | $1.40 | $30.20 |
12/6/2021 0:00 | ACF - Mixes | $104.58 | $7.31 | $111.89 |
12/8/2021 0:00 | ACF - Mixes | $19.95 | $1.39 | $21.34 |
12/7/2021 0:00 | ACF - Mixes | $5.90 | $0.41 | $6.31 |
12/10/2021 0:00 | ACF - Mixes | $73.70 | $4.75 | $78.45 |
12/3/2021 0:00 | ACF - Mixes | $69.16 | $4.84 | $74.00 |
12/9/2021 0:00 | ACF - Mixes - NT | $78.95 | $0.00 | $78.95 |
12/1/2021 0:00 | ACF - Swag - Tax | $23.85 | $0.00 | $23.85 |
12/7/2021 0:00 | ACF - Swag - Tax | $7.99 | $0.56 | $8.55 |
12/6/2021 0:00 | ACF - Swag - Tax | $6.36 | $0.51 | $6.87 |
12/3/2021 0:00 | ACF - Swag - Tax | $7.95 | $0.64 | $8.59 |
12/2/2021 0:00 | ACF - Swag - Tax | $9.99 | $0.70 | $10.69 |
12/10/2021 0:00 | ACF - Thistle & Rose - NT | $17.56 | $0.00 | $17.56 |
12/10/2021 0:00 | ACF - Thistle & Rose - Ta | $516.48 | $33.74 | $550.22 |
12/2/2021 0:00 | ACF - Thistle & Rose - Ta | $56.60 | $2.96 | $59.56 |
12/6/2021 0:00 | ACF - Thistle & Rose - Ta | $168.51 | $6.70 | $175.21 |
12/7/2021 0:00 | ACF - Thistle & Rose - Ta | $42.11 | $1.20 | $43.31 |
12/9/2021 0:00 | ACF - Thistle & Rose - Ta | $162.65 | $10.34 | $172.99 |
12/3/2021 0:00 | ACF - Thistle & Rose - Ta | $143.00 | $8.22 | $151.22 |
12/1/2021 0:00 | ACF - Thistle & Rose - Ta | $29.75 | $0.88 | $30.63 |
12/8/2021 0:00 | ACF - Thistle & Rose - Ta | $200.80 | $8.78 | $209.58 |
ACF - BULK - TAX |
ACF - BULK |
ACF - DRINKS - TAX |
ACF - DRINKS |
ACF - SWAG - TAX |
ACF - SWAG |
ACF - THISTLE & ROSE - TAX |
ACF - THISTLE & ROSE |
ACF - BAKED GOODS - TAX |
ACF - BAKED GOODS |
ACF - GIFT BOXES - TAX |
ACF - GIFT BOXES |
ACF - MISC - TAX |
ACF - MISC |
ACF - SHIPPING |
E STORE SALES - TAX |
E STORE SALES |
FREIGHT & POSTAGE |
ACF - MIXES - TAX |
ACF - MIXES |
ACF - CHOC COVERED ASSORT |
GIFT CARDS SOLD |
OVER/SHORT |