Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Reply
 
Thread Tools Search this Thread Display Modes
Old 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!
allelala is offline   0 Reply With Quote
Old Jun 22, 2011, 12: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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

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


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

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

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