I need to create a worksheet that will keep running totals of two different shipments. The spreadsheet will have tabs for each week and will keep a running total. Here is what I need it to have in each column...
Item Number (same for each tab)
Item Description (same for each tab)
Yield (same for each tab - yield it takes to make one unit)
Total Units (multiply yield by number of units needed for that week)
Sent Units (total units sent for that week)
Balance from last week (pulls balance from last weeks tab remaining balance)
Remaining Balance (balance from last week + sent units - total units)
I have a spreadsheet for one shipment which uses this above but I need to fix it some way that will keep a running total of both shipments but I will be able to pull what remaining balances, sent units, and total units for each shipment. What would be the best way to do this through excel and not be too complicated?