Worksheet 1 is the contents page.
Worksheet 2 is the template page.

Is there any way to hit a button and
a) copy Worksheet 2 and create Worksheet 3.
b) maintain the formatting and cell dimensions.
c) rename the tab (say 03).
d) give a sequential number in a cell. For instance worksheet 2 cell A1
contains the order number 07/0777.
e) Worksheet 03 the order number will go to 07/0778.
f) the order number will go into a cell on the contents page. For example:
Worksheet 1 cell A31 will have order number 07/0777.
Worksheet 1 cell A32 will have order number 07/0778.
g) Repeat the process as for worksheet 5, 6, 7 etc as orders are placed

Many thanks for any assistance that you can provide.

yes very easily
even if you dont know anything about macros,this is a perfect plce to start!
go to tools/macros/record new macro
go through the manual steps you describe and when you have finished hit the
STOP recording button
go tools/ macro/macro1/click and step into or edit and survey with pride the
code you have created!
--
paul

remove nospam for email addy!



"zephyr" wrote:

Worksheet 1 is the contents page.
Worksheet 2 is the template page.

Is there any way to hit a button and
a) copy Worksheet 2 and create Worksheet 3.
b) maintain the formatting and cell dimensions.
c) rename the tab (say 03).
d) give a sequential number in a cell. For instance worksheet 2 cell A1
contains the order number 07/0777.
e) Worksheet 03 the order number will go to 07/0778.
f) the order number will go into a cell on the contents page. For example:
Worksheet 1 cell A31 will have order number 07/0777.
Worksheet 1 cell A32 will have order number 07/0778.
g) Repeat the process as for worksheet 5, 6, 7 etc as orders are placed

Many thanks for any assistance that you can provide.

Paul

I have the spreadsheet working now.

Many thanks for your help it is very much appreciated.

Zephyr

"paul" wrote:

yes very easily
even if you dont know anything about macros,this is a perfect plce to start!
go to tools/macros/record new macro
go through the manual steps you describe and when you have finished hit the
STOP recording button
go tools/ macro/macro1/click and step into or edit and survey with pride the
code you have created!
--
paul

remove nospam for email addy!



"zephyr" wrote:

Worksheet 1 is the contents page.
Worksheet 2 is the template page.

Is there any way to hit a button and
a) copy Worksheet 2 and create Worksheet 3.
b) maintain the formatting and cell dimensions.
c) rename the tab (say 03).
d) give a sequential number in a cell. For instance worksheet 2 cell A1
contains the order number 07/0777.
e) Worksheet 03 the order number will go to 07/0778.
f) the order number will go into a cell on the contents page. For example:
Worksheet 1 cell A31 will have order number 07/0777.
Worksheet 1 cell A32 will have order number 07/0778.
g) Repeat the process as for worksheet 5, 6, 7 etc as orders are placed

Many thanks for any assistance that you can provide.