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.


Participate now!

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