How can I create sequentially numbered invoices in MS Excel for Mac 2008?

allelala · Jun 22, 2011, 12:21 PM

I am trying to create an Excel workbook where I have all entire months invoices and each invoice is on a new sheet in the workbook. How can I make it so that the invoice number on each sheet will be incremented by 1.
So that the first invoice on the first sheet might be 2011-001, and the next invoice on the next sheet could automatically be 2011-002. Is this possible?
All the information about sequential numbers that I could find said that this requires writing macros, which I am not able to do (I don't believe) in the MS Excel for Mac 2008 version.

Any ideas how to do this would be greatly appreciated!

ssmed · Jun 22, 2011, 12:33 PM

Use a formula which references the sheet before

e.g. =Sheet1!A1+1
=Sheet2!A1+1

You could use =INFO("numfile") to get the number of active sheets, but I see problems with this changing existing data.

or have a master sheet at the front with invoice no and contact details on (good for analysis) and reference that.

This is all pretty clumsy though. I would knock up a quick database in Filemaker and manage the whole invoice that way with the potential for analysis and using tables for clients and products/services as well as invoices. They are bound to do a template for this so would be minimal work. Depends on the number of invoices a month I suppose. If a small number manual numbers might be the answer

Jun 22, 2011, 12:21 PM	#1
allelala macrumors newbie Join Date: Jun 2011	How can I create sequentially numbered invoices in MS Excel for Mac 2008? I am trying to create an Excel workbook where I have all entire months invoices and each invoice is on a new sheet in the workbook. How can I make it so that the invoice number on each sheet will be incremented by 1. So that the first invoice on the first sheet might be 2011-001, and the next invoice on the next sheet could automatically be 2011-002. Is this possible? All the information about sequential numbers that I could find said that this requires writing macros, which I am not able to do (I don't believe) in the MS Excel for Mac 2008 version. Any ideas how to do this would be greatly appreciated!
	0

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
thread	Thread Starter	Forum	Replies	Last Post
Excel 11 for Mac on a 27" iMac	Crotonmark	Mac Applications and Mac App Store	2	Sep 12, 2011 02:00 PM
How do I create a PDF invoice with no margins in Numbers '09?	nick_harambee	Mac Applications and Mac App Store	0	Aug 4, 2011 01:34 PM
help with excel for mac 2008	damiang72	Mac Applications and Mac App Store	0	Nov 14, 2010 06:19 AM
Insert calendar in excel for mac 2008	itsmeself	Mac Applications and Mac App Store	2	Sep 27, 2010 03:04 AM
XYChartLabeler.xla doesn't work in Excel for Mac 2008	Coalie	Mac Applications and Mac App Store	1	Jul 1, 2009 10:12 PM

Jun 22, 2011, 12:33 PM	#2
ssmed macrumors regular Join Date: Sep 2009 Location: UK	Use a formula which references the sheet before e.g. =Sheet1!A1+1 =Sheet2!A1+1 You could use =INFO("numfile") to get the number of active sheets, but I see problems with this changing existing data. or have a master sheet at the front with invoice no and contact details on (good for analysis) and reference that. This is all pretty clumsy though. I would knock up a quick database in Filemaker and manage the whole invoice that way with the potential for analysis and using tables for clients and products/services as well as invoices. They are bound to do a template for this so would be minimal work. Depends on the number of invoices a month I suppose. If a small number manual numbers might be the answer
	0


MacRumors Forums > Apple Systems and Services > Mac Basics and Help