Home

Help Creating a Spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-346372%22%20slang%3D%22en-US%22%3EHelp%20Creating%20a%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-346372%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20create%20a%20worksheet%20that%20will%20keep%20running%20totals%20of%20two%20different%20shipments.%26nbsp%3B%20The%20spreadsheet%20will%20have%20tabs%20for%20each%20week%20and%20will%20keep%20a%20running%20total.%26nbsp%3B%20Here%20is%20what%20I%20need%20it%20to%20have%20in%20each%20column...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EItem%20Number%26nbsp%3B%20(same%20for%20each%20tab)%3C%2FP%3E%3CP%3EItem%20Description%20(same%20for%20each%20tab)%3C%2FP%3E%3CP%3EYield%20(same%20for%20each%20tab%20-%20yield%20it%20takes%20to%20make%20one%20unit)%3C%2FP%3E%3CP%3ETotal%20Units%26nbsp%3B%20(multiply%20yield%20by%20number%20of%20units%20needed%20for%20that%20week)%3C%2FP%3E%3CP%3ESent%20Units%26nbsp%3B%20(total%20units%20sent%20for%20that%20week)%3C%2FP%3E%3CP%3EBalance%20from%20last%20week%20(pulls%20balance%20from%20last%20weeks%20tab%20remaining%20balance)%3C%2FP%3E%3CP%3ERemaining%20Balance%20(balance%20from%20last%20week%20%2B%20sent%20units%20-%20total%20units)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%20for%20one%20shipment%20which%20uses%20this%20above%20but%20I%20need%20to%20fix%20it%20some%20way%20that%20will%20keep%20a%20running%20total%20of%20both%20shipments%20but%20I%20will%20be%20able%20to%20pull%20what%20remaining%20balances%2C%20sent%20units%2C%20and%20total%20units%20for%20each%20shipment.%26nbsp%3B%20What%20would%20be%20the%20best%20way%20to%20do%20this%20through%20excel%20and%20not%20be%20too%20complicated%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EBrenda%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-346372%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20-%20formulas%20data%20worksheet%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
sunwers770
Occasional Visitor

Hello,

 

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?

 

Thanks

Brenda

Related Conversations
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies