number increasing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TechnoGram - 22 Oct 2007 10:59 GMT

Is there a way in a master worksheet to put a formula in a cell which
contains a number such as 15846 and have that number increase by one
in the same cell when you make a copy of the original worksheet.

Reply to this Message

CLR - 22 Oct 2007 20:28 GMT

Not as you ask it........but if you would describe your end desire in a
little more detail, perhaps someone can suggest another method....

Vaya con Dios,
Chuck, CABGx3

> Is there a way in a master worksheet to put a formula in a cell which
> contains a number such as 15846 and have that number increase by one
> in the same cell when you make a copy of the original worksheet.

Reply to this Message

TechnoGram - 11 Nov 2007 00:58 GMT

> Not as you ask it........but if you would describe your end desire in a
> little more detail, perhaps someone can suggest another method....
[quoted text clipped - 7 lines]
>
> - Show quoted text -

Invoice number on invoice form. Thanks for the help

Reply to this Message

Pete_UK - 11 Nov 2007 01:22 GMT

Have a look at this link:

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

Hope this helps.

Pete

> Invoice number on invoice form. Thanks for the help

Reply to this Message

TechnoGram - 25 Nov 2007 23:34 GMT

> Have a look at this link:
>
[quoted text clipped - 7 lines]
>
> - Show quoted text -

Stored the code given in the above link into a new blank workbook and
saved it as a template. When I open a new workbook it shows as
Workbook1, Workbook2 etc. This is good but not quite what I was
thinking of.
In the example where B2 is where I want a number, say 1234, to be in
the master sheet with all the formulas. Then when you make a copy of
the sheet within the same workbook the number in b2 would increase by
1 each time the master is copied.
Can this be done?

Reply to this Message