Name of sheet is based on cell value

ryan0521

ryan0521

Board Regular
Joined
Dec 7, 2016
Messages
79
Happy new year to all,

Can you help me to name sheets in workbook based on cell value specifically (J2).

Thank you in advance.
 
Sort by date Sort by votes
I'm sorry, I thought it works for all the sheets.

All (J2) of sheets are linked to J2 of sheet1. I want to rename the sheets based on the value of their corresponding (J2). When I tried to put all your codes and change the value of (J2) in sheet1 only the name of sheet1 changed and others didn't changed but the value of their (J2) already changed.
 
Upvote 0

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
what formula are you using in the other sheets ?
How many "other" sheets are there ??
 
Upvote 0
It depends, but up to maximum of 26 sheets, my formula for sheet2 is =CHAR(CODE(sheet1!J2)+1) for sheet 3 =CHAR(CODE(sheet2!J2)+1) so on and so forth
 
Upvote 0
You must log in or register to reply here.

Similar threads

I
  • Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
372
Insurance Dave
I
B
  • Solved
VBA to delete certain sheets based on cell contents with IF formula
Replies
3
Views
265
Peter_SSs
Peter_SSs
K
  • Question
VBA for Deleting Sheets & Save As Based on Column Values
Replies
5
Views
227
krisoey
K
J
  • Question
VBA to make Sheet Name = Cell Value
2
Replies
15
Views
674
Joe4
Joe4
P
  • Question
Need VBA to automatically copy paste rows based on dates of current month.
2
Replies
11
Views
384
pk970
P

Forum statistics

Threads
1,216,085
Messages
6,128,733
Members
449,465
Latest member
TAKLAM

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top