PDA

View Full Version : Changing numbers automatically in excel


nanc1430
Oct 5, 2008, 10:45 PM
I have excel 2000 on my computer and downloaded a free invoice template.
Over on the upper right it says invoice and then a blank for you to fill it in.
I filled in a number and wanted to know if there is any way to have the invoice number change as I use the invoices without doing it manually?
Thank you
nanc1430

JBeaucaire
Oct 5, 2008, 10:49 PM
This web page shows two ways to do this exact thing:

McGimpsey & Associates : Excel : Sequential numbers (http://www.mcgimpsey.com/excel/udfs/sequentialnums.html)

nanc1430
Oct 6, 2008, 12:45 AM
Thank you very much. I have been trying to do this all day.
nanc1430