Clicking insert worksheet and it brings up template

S

SGagne

Hi,

I'm working on a file that when I click "Insert, Worksheet", I then want
that worksheet to load the same exact information from Sheet 1 (which acts as
a template). How can I do this, I'm stumped.

Thanks.
 
E

Ernesto

Select the worksheet you want to work as template
Right click on it
It will pop-up a menu box
Select Move or Copy
Check the Copy box
Click ok
 
Top