I am trying to find a formula (I know how to use some basic formulas in this
programme) that let me have sequential numbers on different worksheets in a
workbook. I have developed an invoice and need to have a new number come up
on each different worksheet (I dont have any formula here at the moment).
Any help in this problem would be greatly appreciated

How are you creating a different sheet for each new invoice?

Copying a sheet and re-doing it?

Or something else?


Gord Dibben MS Excel MVP

On Mon, 9 Jun 2008 17:15:01 -0700, tacks
wrote:

I am trying to find a formula (I know how to use some basic formulas in this
programme) that let me have sequential numbers on different worksheets in a
workbook. I have developed an invoice and need to have a new number come up
on each different worksheet (I dont have any formula here at the moment).
Any help in this problem would be greatly appreciated

I spoke to a person at microsoft and he said that you are unable to put a
formula into a workbook so that everytime you open one you get a new number
but you are able to do this within the same workbook but on different
worksheets. So I typed up our invoice to suit us and then copied it onto all
the different worksheets. I have so far entered the numbers manually as I
cannot figure out how to do this or even if we're better off using a
different product. It has been 8 years since I stopped work and stopped
using this program every day so I'm strugglin to remember some things

"Gord Dibben" wrote:

How are you creating a different sheet for each new invoice?

Copying a sheet and re-doing it?

Or something else?


Gord Dibben MS Excel MVP

On Mon, 9 Jun 2008 17:15:01 -0700, tacks
wrote:

I am trying to find a formula (I know how to use some basic formulas in this
programme) that let me have sequential numbers on different worksheets in a
workbook. I have developed an invoice and need to have a new number come up
on each different worksheet (I dont have any formula here at the moment).
Any help in this problem would be greatly appreciated

Have a look at John McGimpsey's site for how-to code for creating sequential
numbering for invoices.

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

Create a Template workbook and open it to create a workbook for each new
invoice.

Use John's code to sequentially number them.


Gord

On Wed, 11 Jun 2008 16:14:03 -0700, tacks
wrote:

I spoke to a person at microsoft and he said that you are unable to put a
formula into a workbook so that everytime you open one you get a new number
but you are able to do this within the same workbook but on different
worksheets. So I typed up our invoice to suit us and then copied it onto all
the different worksheets. I have so far entered the numbers manually as I
cannot figure out how to do this or even if we're better off using a
different product. It has been 8 years since I stopped work and stopped
using this program every day so I'm strugglin to remember some things

"Gord Dibben" wrote:

How are you creating a different sheet for each new invoice?

Copying a sheet and re-doing it?

Or something else?


Gord Dibben MS Excel MVP

On Mon, 9 Jun 2008 17:15:01 -0700, tacks
wrote:

I am trying to find a formula (I know how to use some basic formulas in this
programme) that let me have sequential numbers on different worksheets in a
workbook. I have developed an invoice and need to have a new number come up
on each different worksheet (I dont have any formula here at the moment).
Any help in this problem would be greatly appreciated

Thank you for your help with this I've had a look and I'll give it a try.

"Gord Dibben" wrote:

Have a look at John McGimpsey's site for how-to code for creating sequential
numbering for invoices.

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

Create a Template workbook and open it to create a workbook for each new
invoice.

Use John's code to sequentially number them.


Gord

On Wed, 11 Jun 2008 16:14:03 -0700, tacks
wrote:

I spoke to a person at microsoft and he said that you are unable to put a
formula into a workbook so that everytime you open one you get a new number
but you are able to do this within the same workbook but on different
worksheets. So I typed up our invoice to suit us and then copied it onto all
the different worksheets. I have so far entered the numbers manually as I
cannot figure out how to do this or even if we're better off using a
different product. It has been 8 years since I stopped work and stopped
using this program every day so I'm strugglin to remember some things

"Gord Dibben" wrote:

How are you creating a different sheet for each new invoice?

Copying a sheet and re-doing it?

Or something else?


Gord Dibben MS Excel MVP

On Mon, 9 Jun 2008 17:15:01 -0700, tacks
wrote:

I am trying to find a formula (I know how to use some basic formulas in this
programme) that let me have sequential numbers on different worksheets in a
workbook. I have developed an invoice and need to have a new number come up
on each different worksheet (I dont have any formula here at the moment).
Any help in this problem would be greatly appreciated