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

Discussion in 'Mac Basics and Help' started by allelala, Jun 22, 2011.

  1. macrumors newbie

    Joined:
    Jun 22, 2011
    #1
    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!
     
  2. macrumors 6502

    Joined:
    Sep 28, 2009
    Location:
    UK
    #2
    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
     

Share This Page