Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What you are trying to do in Assignment 6 is to have VBA calculate Monthly Sales for each of the 5 Sellers that are in

image text in transcribed
What you are trying to do in Assignment 6 is to have VBA calculate Monthly Sales for each of the 5 Sellers that are in cells I6:I10. Furthermore, you will calculate the TOTAL sales in cell I11. Your approach should adapt to the size of the data in this sales sheet. In other words, there are 11 rows shown in the data here (and in the starter file), yet your sub should work the same if we had 20 rows, for example, or 50 rows. The format of this sheet will always be the same (headers will be in row 5).
Next, you need to have VBA automatically calculate the Total Boxes of each of the 3 different cookies in cells I14:I16. The attached file is what it is supposed to be. Initially they're all blank. I can't figure out how to code this. Is there an easy loop that I'm not understanding?
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Survey Of Accounting

Authors: Paul D. Kimmel, Jerry J. Weygandt

2nd Edition

1119594537, 978-1119594536

More Books

Students also viewed these Accounting questions