Inventory-move Shipped Units To Subtotal Sheet

  • I have an inventory sheet and wrote a macro to move ending units to begining and post as range value.


    Then moved range "ship" to Total Shipped sheet and posted to the last row.


    Recalculated and sub-totaled the Total Shipped sheet.


    Then zeroed out Rec units


    and Shipped units. This will allow new entries.



    PROBLEM; I don't know how to post "ship" range in the Total Shipped sheet and calculate a new sub-total.


    The macro didn't work.


    Thanks,

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!