G
Guest
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.
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.