I have a spreadsheet that contains two worksheets. One is the contents page
and the other is a template. The template has a command button when pressed
creates a new worksheet.

The new worksheets are allocated a number in sequence.

Each time a worksheet is created from the template I would like it to
1) create a order number 06/775 and put this into cell A1 on worksheet 1.
The order number in cell A1 is updated each time a worksheet is created.
2) put the order number into cell C7 in the contents worksheet.
3) when worksheet 2 is created update the order number in cell A1 to 06/776.
4) put the order number into cell C8 in the contents worksheet

If this is possible any help is appreciated.

Many thanks

Try doing a Google Search; excel sub invoice
and a Google Groups Search: group:*excel* sub invoice
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"zephyr" wrote in message ...
I have a spreadsheet that contains two worksheets. One is the contents page
and the other is a template. The template has a command button when pressed
creates a new worksheet.

The new worksheets are allocated a number in sequence.

Each time a worksheet is created from the template I would like it to
1) create a order number 06/775 and put this into cell A1 on worksheet 1.
The order number in cell A1 is updated each time a worksheet is created.
2) put the order number into cell C7 in the contents worksheet.
3) when worksheet 2 is created update the order number in cell A1 to 06/776.
4) put the order number into cell C8 in the contents worksheet

If this is possible any help is appreciated.

Many thanks