How to create multiple sheets with same template in every sheet?

Question

Dear all experts,

I need help on two tasks here.

I tried to create the Purchasing Order from the template that excel 2007 gave me.

My tasks are to

1. create multiple sheet within this file, with all sheet held the same template,
2. In wach page, it would be one box I would like to have it run the number

(each of them should contain "PO number" inside its page and  "PO number" should be run from page to page...I wonder how can i do this? any formula?)

pals, I am now doing it manually and individually.

really neded help on this

I believe Experts could clarify me this.

Thank you

Answer 1

The following Macro will auto insert the template sheet and assign it a number. You may have a shortcut for the macro. Hope you are using VBA, otherwise post back for a more detailed explanation.

Sub Macro1()

Dim MaxNum As Integer

Sheets(Sheets.Count).Select

MaxNum = ActiveSheet.Range("F8").Value

Sheets.Add After:=ActiveSheet, Type:= "C:\Program Files\Microsoft Office\Templates\1033\BillingStatement.xltx"

ActiveSheet.Range("F8").Value = MaxNum + 1

End Sub

All you need to do is change the path to the path of your template and change the cell reference F8 to whereever your autonumber lies.

Hope this helps.

Vinay

Answer 2

On the sheets tab, Right Click and Select INSERT... 

This will permit you to create a sheet from an existing template.