Re: Auto Assigning Number to Excel Invoice

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

This link shows you two ways of maintaining these sequential numbers
for invoices etc.:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Hope this helps.

Pete

On Jun 10, 9:09 am, Angela Rose <Angela
R...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I have been using a template created in Excel 2000 for my business invoices
for 7 years.  This template had a tool box which allowed me to assign a
sequential new number for each invoice automatically by clicking assign new
number.  Is this feature available in Excel 2007?  I have tried enabling
macros which were used on the previous version, but each time I attempt to
run them, I get the message "The numbering add-in must be loaded for optimal
numbering and toolbar behavior.  Please load this add-in into your Library
Directory."  Where do I find this add-in? It is not located in Excel 2007 and
I cannot find it on available downloads on Microsoft web-site... which is
where I am directed from the help menu.   PLEASE HELP!!

.

Relevant Pages

  • Re: Auto Assigning Number to Excel Invoice
    ... Then load it as an add-in. ... "Angela Rose" ... Is this feature available in Excel 2007? ... Please load this add-in into your Library ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Find cells in a range that sum to an amount
    ... clients. ... Sometimes I get a check with an amount for some of the invoices, but I don't know which invoices the check goes with. ... Is there a function or add-in that can look at all the invoice amounts and find one or more that add up to the check amount? ...
    (microsoft.public.excel)
  • Re: Find cells in a range that sum to an amount
    ... There have been a lot of contributions to problems like yours over the ... but I don't know which invoices the check goes with. ... up to the check amount? ... Is there an add-in or other code to help me do this? ...
    (microsoft.public.excel)
  • Find cells in a range that sum to an amount
    ... clients. ... Sometimes I get a check with an amount for some of the invoices, ... add-in that can look at all the invoice amounts and find one or more that add ... Is there an add-in or other code to help me do this? ...
    (microsoft.public.excel)