Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sequential invoice numbering
Hi there,
I have designed my own invoice in exel, in the same workbook as the invoice I have an invoicing sheet with a custom invoice no's. collum and a client name collum, to keep record of invoice numbers that had been used. What I need is to prevent duplicating invoice numbers by way of a formula that can generate the next available invoice number. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sequential invoice numbering
Private Sub Worksheet_Activate() Sheets("Invoice Form").Select ActiveSheet.Unprotect Range("A1") = Range("A1").Value + 1 End Sub If you put this in the worksheet code every time you return to the sheet it will increment the value of A1 by 1, make sure there is a value there every time you open the workbook to that sheet or come back to that sheet it will increase the number.......Crude but it works! P.s you can always set the value of the cell to be a figure HTH Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=550262 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up excel invoice t/plate with sequential numbering | Excel Discussion (Misc queries) | |||
Data tracking and auto sequential numbering | Excel Worksheet Functions | |||
In Excel, how do I setup sequential numbering on an invoice? | Excel Worksheet Functions | |||
sequential numbering for invoice | Excel Worksheet Functions | |||
How do I get automatic sequential numbering when using an invoice. | Excel Discussion (Misc queries) |