Thread: Auto rename tab
View Single Post
 
Old 10-19-2015, 11:45 AM
orozvik@yahoo.com orozvik@yahoo.com is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Apr 2015
Posts: 8
orozvik@yahoo.com is on a distinguished road
Cool Auto rename tab

Anyone have a clue how to automatically rename sheet tabs to a name in a cell in another tab?

So, if sheet 1 in A2 has the Value "OAC-125" then the following tab names would be updated with that name as follows:

Sheet 2 - Current Name: DAR Updated to: OAC-125 DAR
Sheet 3 - Current Name: ZKL Updated to: OAC-125 ZKL

you get it ha? I thought maybe some formula can be entered with the concatenate symbol in each tab like this:

Sheet 2 - Sheet 1! A2 & DAR

Any idea guys/gals? thank.s
Reply With Quote