ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Clicking insert worksheet and it brings up template (https://www.excelbanter.com/excel-discussion-misc-queries/216754-clicking-insert-worksheet-brings-up-template.html)

SGagne

Clicking insert worksheet and it brings up template
 
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.

Ernesto

Clicking insert worksheet and it brings up template
 
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

"SGagne" wrote:

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.



All times are GMT +1. The time now is 09:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com