incrementing account numbers

Hi John,

Have a look here, J.E. has it figured out quite nicely.

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

HTH
Regards,
Howard

"John" <John@discussions.microsoft.com> wrote in message
news:442252FB-6CC7-4740-BD84-3AFF00104992@microsoft.com...
> Hi,
>
> I'm having a lot of issues here understanding how to use a the macro's
> with
> an Excel 2003 workbook.
>
> The scenario is to create an invoice and each must have a different
> invoice
> number which will be incremented by 1 each time I use the workbook. I'll
> actually want to save-as the workbook to a new one per invoice.
>
> I spent the afternoon reading threads and trying out various macro's and
> got
> myself totally lost. In the end I deleated the workbook which had about
> 10
> different macro's in it. I'd like to just start all over from scratch.
> The
> invoice itself isn't complicated and can be drawn up in 10 minutes, it is
> just increasing the invoice number that I have trouble with.
>
> I'd like to know why MS didn't just include this.. it has everything else.

Thanks

It seems to try and work, but I'm getting a message saying that macro's are
disabled because of a high security level and I can either lower it or
request that macros be digitally signed... What security? In excel or a
firewall or what?

Also, I forgot to meantion that in another cell the invoice number has to
appear. The cells are E 1 and E 19. Do I have to make two macro's?

John

"L. Howard Kittle" wrote:

> Hi John,
>
> Have a look here, J.E. has it figured out quite nicely.
>
> http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
>
> HTH
> Regards,
> Howard
>
> "John" <John@discussions.microsoft.com> wrote in message
> news:442252FB-6CC7-4740-BD84-3AFF00104992@microsoft.com...
> > Hi,
> >
> > I'm having a lot of issues here understanding how to use a the macro's
> > with
> > an Excel 2003 workbook.
> >
> > The scenario is to create an invoice and each must have a different
> > invoice
> > number which will be incremented by 1 each time I use the workbook. I'll
> > actually want to save-as the workbook to a new one per invoice.
> >
> > I spent the afternoon reading threads and trying out various macro's and
> > got
> > myself totally lost. In the end I deleated the workbook which had about
> > 10
> > different macro's in it. I'd like to just start all over from scratch.
> > The
> > invoice itself isn't complicated and can be drawn up in 10 minutes, it is
> > just increasing the invoice number that I have trouble with.
> >
> > I'd like to know why MS didn't just include this.. it has everything else.
>
>
>

Thanks

It seems to try and work, but I'm getting a message saying that macro's are
disabled because of a high security level and I can either lower it or
request that macros be digitally signed... What security? In excel or a
firewall or what?

Also, I forgot to meantion that in another cell the invoice number has to
appear. The cells are E 1 and E 19. Do I have to make two macro's?

John

"L. Howard Kittle" wrote:

> Hi John,
>
> Have a look here, J.E. has it figured out quite nicely.
>
> http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
>
> HTH
> Regards,
> Howard
>
> "John" <John@discussions.microsoft.com> wrote in message
> news:442252FB-6CC7-4740-BD84-3AFF00104992@microsoft.com...
> > Hi,
> >
> > I'm having a lot of issues here understanding how to use a the macro's
> > with
> > an Excel 2003 workbook.
> >
> > The scenario is to create an invoice and each must have a different
> > invoice
> > number which will be incremented by 1 each time I use the workbook. I'll
> > actually want to save-as the workbook to a new one per invoice.
> >
> > I spent the afternoon reading threads and trying out various macro's and
> > got
> > myself totally lost. In the end I deleated the workbook which had about
> > 10
> > different macro's in it. I'd like to just start all over from scratch.
> > The
> > invoice itself isn't complicated and can be drawn up in 10 minutes, it is
> > just increasing the invoice number that I have trouble with.
> >
> > I'd like to know why MS didn't just include this.. it has everything else.
>
>
>