Dynamically Update an Excel Cell When You Rename a Worksheet Tab

[Ratsathome]

Great vids.Looking for info on the reverse of this vid?I want to enter a name in a cell and it must change a work sheet name for me.(Input a name in cell A1-Sheet1-change sheet 3 name).

Regards

[arribalaschivas123]

Is there a way to do it the other way around? I mean, by changing the cell name, channges de tab name.

Please!

[DannyRocksExcels]

@arribalaschivas123

Sorry for the delay in responding - I missed the initial notice of your comment.

To "reverse this" process - to change the name of the worksheet tab based up the change in a cell would require writing some VBA Code.

I am starting to work on a series of "extended length" videos that cover VBA and I will include this in the series - it will be another couple of months before this is ready.

Danny Rocks

The Company Rocks

[DannyRocksExcels]

@arribalaschivas123

As promised, I have created a video that shows you how to do this - it is here on YouTube. Title is "Write a Macro to Update Worksheet Tab Name."

Danny Rocks

The Company Rocks

[arribalaschivas123]

@DannyRocksExcels

Thanks a lot!! it was really helpfull and easy since I'm still a starter in Visual Basic...

Thank you

[DannyRocksExcels]

@arribalaschivas123

My pleasure. We all start somewhere. This is a good example of what VBA (Visual Basic for Applications) can do to help you be more productive in Excel.

Danny Rocks

The Company Rocks