Hello, oh wise gurus of the forum!
I'm working on coming up with a few Macros which can assist with some of the
monthly billing worksheets utilized by my company. There are a whole lot of different things that need to be done to
prepare, plus a whole other set of steps that need to be done to actually fill in all billing info.
this from being a huge post outlining every different thing that needs to be done, I would like to post several different
ones (maybe one post per every couple of days or so) until I've addressed each process individually. I'm still learning the
company's billing process along the way, as well, so please bear with me with each of my posts.
That being said,
I come to you with what I hope will be a fairly easy one at first.
Column A lists a product ID code. Column B
lists the product name.
In column C is the beginning inventory for the previous month. Columns D & E are
additions and subtractions that occurred to the inventory for each product for this month. Column F is the ending inventory
for the month.
Hence, column F = C+D-E
Each of the columns C, D, E, and F have a SUM formula in the
Pretty easy so far, right?
I'm seeking a Macro that can "prep" these columns each month
for our inventory changes in columns C and D to be entered to present new values in F. Put a little more simply, the Macro
1. Take the value of F (NOT the formula) and copy it into C.
2. Put a "0" in every cell of D and E.
3. End this process when it reaches the row that has the SUM formulas.
I have been pretty successful in doing
1. and 2. above, but I'm having trouble telling it where to stop cutting and pasting. It would be ok if there were a set
number of products, as I would simply cut and paste the range of cells in F and copy into C. However, the number of products
change from month-to-month. For one month, there may be 30 products. For the next, there may be 27, or 35 or 40, or any
Can anyone help with this one?
Thanks so much for your time and your assistance!