G Guest Nov 29, 2004 #1 I have made an invoice on Excel. I want the Invoice Numbers to increase by one each time. How do I do a formula for this?
I have made an invoice on Excel. I want the Invoice Numbers to increase by one each time. How do I do a formula for this?
G Guest Nov 29, 2004 #2 Hi this is not possible with formulas. This would require VBA. e.g. see: http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
Hi this is not possible with formulas. This would require VBA. e.g. see: http://www.mcgimpsey.com/excel/udfs/sequentialnums.html