I hope someone can help me with my problem. I have a spreadsheet with columns for product inventory (Columns go from A to R) - Date Received, ID, Current Stock, costs etc. and the rows are the specific products (approx 125 rows to date). I am trying to create a macro that will insert a new row based on the difference between the inventory in and out values along with the commission and markup formulas in columns K to P.
Current Stock (Col F) is the number of items for that product at hand, say 10,000.
Shipped stock (Col J) is the number of items sent out.
If I enter 2,000 into Shipped Stock (Col J Row 10) a new row will be inserted (Row 11) with Col J in the Row 11 blank and the formula from col K to Col P will also be applied to the new row. If I then enter another shipment out value in Col J Row 11, say, 3,000 it will insert a new row again (row 12). New rows can be continually added until the Value in Col F minus value in Col J equal zero. However, if all the stock shipped is equal to the current stock (col J = Col F) then no new row appears.
I don’t know if this can be done or not but any help would be greatly appreciated