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.