What you are trying to do in Assignment 6 is to have VBA calculate Monthly Sales for
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667afbe967708_912667afbe8cfb1e.jpg)
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?
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667afbe9d3f6f_913667afbe9cbe4d.jpg)
Posted Date: