How to rename sheets in Excel with Pivot table and VBA code?

Most of us rename sheets by right clicking on mouse and the click on rename.

See the image Below

Rename of Worksheet

Let's learn some tricks to do this process in seconds

Learn how to rename sheets using VBA Code and Pivot Table

https://youtu.be/FbL540jKZVU

This is the link of the Video.

WATCH THIS VIDEO
AND FOLLOW THE STEPS

I have given three tricks, follow all these tricks and do your work in seconds

# TRICK 1

Step 1

Type your data which you want in your sheet names.

Like I want all the month names in separate sheets.

Step 2

Select your data.

Go to INSERT Tab and then select Pivot Table.

Step 3

Move the MONTH into the Report Filter box

Step 4

Go to OPTIONS Tab- Options- Show Report filter pages

Step 5

Now, you got your sheets RENAMED.

#TRICK 2

Step 1

Select any Sheet and right click on it.

Then select VIEW CODE.

Step 2

Go to INSERT - Module.

A new sheet will appear, COPY (Ctrl + C) and PASTE (Ctrl +v) the data given below.

SubChangeWorkSheetName()
 Dim Rng As Range
 Dim WorkRng As Range
 On Error Resume Next
 newName = Application.InputBox(“Name”,xTitleId, “”, Type:=2)
 For i = 1 To Application.Sheets.Count
 Application.Sheets(i).Name = newName & i
 Next
 End Sub

Step 3

Close that Sheet.

Step 4

Go to VIEW tab - MACROS - Select your macro.

i.e. CHANGEWORKSHEETNAME.

Step 5

Simply type any name.

Then CLICK on OK.

Step 6

Now all the sheets are RENAMED in Excel.

#TRICK 3

Do the same steps as shown in TRICK 2 to rename your sheet.

Step 1 to Step 3 are same.

Step 4

Go to INSERT tab - Select any shape from Shapes.

Step 5

Right click on that shape and Click on ASSIGN MACROS.

Step 6

Select your MACRO (CHANGEWORKSHEETNAME) and Click on OK.

Step 7

Now Click on that shape and TYPE any name which you want in your RENAMED SHEET.

FOR EXAMPLE, I typed 'WEEK' and all the WORKSHEETS in Excel got RENAMED automatically.

WATCH THE VIDEO TO UNDERSTAND BETTER.

PLEASE LIKE, SHARE & SUBSCRIBE MY CHANNEL (EXCEL LEARNING) ALSO.