Creating a new Invoice and Auto Invoice Number in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2717217%22%20slang%3D%22en-US%22%3ECreating%20a%20new%20Invoice%20and%20Auto%20Invoice%20Number%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2717217%22%20slang%3D%22en-US%22%3E%3CP%3EUsing%20an%20Excel%20Invoice%20Template%2C%20how%20do%20I%20create%20an%20auto%20Invoice%20Number%3F%20Say%20I%20have%20a%20new%20invoice%20set%20up%20in%2010%20worksheets%20to%2010%20various%20vendors%20and%20I%20want%20each%20number%20(alphanumeric)%20to%20be%20generated%20automatically.%26nbsp%3B%20I%20know%20how%20to%20reference%20a%20cell%20in%20another%20worksheet%20but%20how%20do%20I%20make%20it%20run%20sequentially%20in%20separate%20invoices%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2717217%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Using an Excel Invoice Template, how do I create an auto Invoice Number? Say I have a new invoice set up in 10 worksheets to 10 various vendors and I want each number (alphanumeric) to be generated automatically.  I know how to reference a cell in another worksheet but how do I make it run sequentially in separate invoices?

1 Reply
can you share the template you're using