Note: In the above code, you can change the worksheet name text “ KTE-” to your needed. Enter the number of copies into the popped dialog, and then click OK button, your current worksheet has been duplicated 5 copies and renamed with sequence name as following screenshot shown:
Then press F5 key to run this code, and a prompt box will remind you how many copies of the current worksheet that you want to copy, see screenshot:Ĥ. XActiveSheet.Copy After:=ActiveWorkbook.Sheets(xName)ģ. XNumber = InputBox("Enter number of times to copy the current sheet") VBA code: Copy a worksheet multiple times and rename at once: Sub Create() Click Insert > Module, and paste the following code in the Module Window. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.Ģ. If you need to copy a worksheet multiple times, and give them series names, such as KTE-1, KTE-2, KTE-3, KTE-4…, the following VBA code can do you a favor.ġ.
MOVE OR COPY SHEET IN EXCEL FOR MAC HOW TO
In Excel, how could you copy a worksheet and rename it automatically without typing the name as usual? In this article, I will talk about how to copy a sheet one time or multiple times and give them specific names at once.Ĭopy a worksheet multiple times and rename them with increment tab names by using VBA codeĬopy a worksheet multiple times and rename them with custom names by using Kutools for Excel How to copy sheet and rename automatically in Excel?
0 kommentar(er)
