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

Reply
 
Thread Tools Search this Thread Display Modes
Old Jun 22, 2011, 01: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!
allelala is offline   0 Reply With Quote
Old Jun 22, 2011, 01:33 PM   #2
ssmed
macrumors 6502
 
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
ssmed is offline   0 Reply With Quote

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

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Visual Basic Module/Macro works in Windows Excel but not Mac Excel 2011 chrispy1042 Mac Applications and Mac App Store 2 May 4, 2014 08:41 AM
Templates for Microsoft Excel - Best Excel Spreadsheets for Mac! Alexander-James Mac Applications and Mac App Store 1 Apr 24, 2014 02:19 AM
Charting Mac Excel 2008 sharingsunshine Mac Applications and Mac App Store 4 Aug 27, 2013 03:57 PM
Formulas in Excel on Mac... Switch to values in Excel on PC Noob2mac Mac Applications and Mac App Store 2 Apr 24, 2013 06:24 AM
How to create the list of worksheets in an excel file? 2008 oyl2008 Mac Basics and Help 1 Nov 17, 2012 08:20 PM

Forum Jump

All times are GMT -5. The time now is 10:22 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC