Loading existing sheet as new sheet with same data

Copper Contributor

Hi, 

 

Can you use your initial worksheet as a permanent template so when i open a new sheet, it will have the same text as the first sheet? instead of having to copy the sheet everytime?

 

Thanks in advance

1 Reply

@ParkerJC 

If you want every new sheet in every workbook to be a copy of that sheet, it would be possible, but I assume that is not what you meant.

For a single workbook, you'll have to copy the first sheet each time you need a new sheet. If you wish, you could create a macro for that and assign a keyboard shortcut to it, and/or a custom Quick Access Toolbar button, but that seems a bit over the top. Let us know if you want that.