How to dynamically change a tab name in excel?

Microsoft Excel 2013 32/64-bit
January 28, 2015 at 11:40:54
Specs: Windows 7
How can I dynamically change the name of a tab in Excel based on a cell on another sheet?

Example: if sheet 1 has a cell with January in it as text. How can I make the name of the tab on sheet 2 change based on that cell?

'Sheet1'!G16 = January - Tab 2 name would become January and then tab 3 would become February and so on.


See More: How to dynamically change a tab name in excel?

Report •

#1
January 28, 2015 at 12:34:01
You will need a Macro to accomplish what you want, unfortunately my Macro skills are just above nil, but here is a page that should help:

http://www.atlaspm.com/toms-tutoria...

MIKE

http://www.skeptic.com/


Report •

#2
January 28, 2015 at 12:42:11
Unfortunately that seems to apply only to data on the same sheet which I have been able to do but is not what I am looking for.

Thank You though


Report •
Related Solutions


Ask Question