Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to automatically populate the next available invoice #
I have a invoice in excel and I want a certain cell to automatically enter
the next invoice availalbe. How can I make that happen? How will it know what was the last invoice. I once had a PO template that was in excel and it automatically populated the next available PO #? Amy help will be appreciated. Thanks, Laurie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to automatically populate the next available invoice #
We need more info, i assume u just want the next number in the
sequence, therefor it has to know what the last numer was, which I assume comes of the last invioce, so u have to somehow make the current invoice pick up this information.. Just explain your question a bit better... Laurie wrote: I have a invoice in excel and I want a certain cell to automatically enter the next invoice availalbe. How can I make that happen? How will it know what was the last invoice. I once had a PO template that was in excel and it automatically populated the next available PO #? Amy help will be appreciated. Thanks, Laurie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I automatically assign an invoice number in Excel 2003 (I . | Excel Discussion (Misc queries) | |||
how does an invoice number change automatically ? | New Users to Excel | |||
getting multiple data to populate another worksheet | Excel Worksheet Functions | |||
Automatically Populating Worksheet from Collected Input for Pricelist | Excel Worksheet Functions | |||
Automatically Populating Worksheet from Collected Input for Pricelist | Excel Worksheet Functions |