Answered step by step
Verified Expert Solution
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
What you are trying to do in Assignment is to have VBA calculate Monthly Sales for each of the Sellers that are in cells I:I Furthermore, you will calculate the TOTAL sales in cell I Your approach should adapt to the size of the data in this sales sheet. In other words, there are rows shown in the data here and in the starter file yet your sub should work the same if we had rows, for example, or rows. The format of this sheet will always be the same headers will be in row
Next, you need to have VBA automatically calculate the Total Boxes of each of the different cookies in cells I:I 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 Im not understanding?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started