Running Total

%3CLINGO-SUB%20id%3D%22lingo-sub-1502369%22%20slang%3D%22en-US%22%3ERunning%20Total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1502369%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20trying%20to%20create%20a%20running%20total%20for%20a%20spreadsheet%20from%20an%20invoice%20template.%3C%2FP%3E%3CP%3EI%20am%20wondering%20how%20to%20keep%20the%20total%20running%20when%20I%20have%20closed%20the%20spreadsheet.%20Kind%20of%20like%20advancing%20the%20invoice%20number%20using%20Macros%20and%20VBA%2C%20but%20to%20keep%20the%20number%20of%20uses%20of%20a%20machine.%20Any%20assistance%20would%20be%20greatly%20appreciated.%20As%20of%20right%20now%2C%20I%20have%20it%20so%20that%20there%20is%20a%20%22maintenance%22%20message%20allowing%20the%20person%20using%20the%20spreadsheet%20that%20once%20the%20number%20of%20uses%20reaches%20700%2C%20it%20reminds%20the%20user%20to%20change%20the%20oil%20on%20the%20machine.%20If%20there%20was%20or%20is%20a%20way%20to%20%22recall%22%20the%20number%20that%20was%20in%20the%20cell%20from%20the%20previous%20invoice%2C%20and%20then%20add%20the%20new%20amount%20to%20it.%20That%20is%20what%20I%20am%20trying%20to%20do.%20Any%20assistance%20would%20be%20greatly%20appreciated!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1502369%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

Hi, I'm trying to create a running total for a spreadsheet from an invoice template.

I am wondering how to keep the total running when I have closed the spreadsheet. Kind of like advancing the invoice number using Macros and VBA, but to keep the number of uses of a machine. Any assistance would be greatly appreciated. As of right now, I have it so that there is a "maintenance" message allowing the person using the spreadsheet that once the number of uses reaches 700, it reminds the user to change the oil on the machine. If there was or is a way to "recall" the number that was in the cell from the previous invoice, and then add the new amount to it. That is what I am trying to do. Any assistance would be greatly appreciated!!

0 Replies