Forum Discussion
Loading existing sheet as new sheet with same data
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? Thank...
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.