Jul 04 2021 06:22 AM
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
Jul 04 2021 08:47 AM
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.