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

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
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
446
Insurance Dave
I
B
  • Solved
VBA to delete certain sheets based on cell contents with IF formula
Replies
3
Views
326
Peter_SSs
Peter_SSs
M
  • Question
VBA macro required to change tab name based on cell value
Replies
4
Views
171
mumps
mumps
K
  • Question
VBA for Deleting Sheets & Save As Based on Column Values
Replies
5
Views
255
krisoey
K
J
  • Question
VBA to make Sheet Name = Cell Value
2
Replies
15
Views
775
Joe4
Joe4

Forum statistics

Threads
1,216,746
Messages
6,132,476
Members
449,729
Latest member
davelevnt

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