Dynamically Update an Excel Cell When You Rename a Worksheet Tab

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
1,286
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Apr 7, 2011

This is a great tip! Several of my viewers have asked me to show them how to link a cell to the name of an Excel Worksheet Tab.

I show you how to create the formula so that - e.g. Cell C1 - will automatically update when you change the worksheet name from "Sheet1" to "January."

If you use templates, this is a great tip to learn!

I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to view all of my videos and to explore the many resources that I offer.

Danny Rocks
The Company Rocks

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (6)

Sign In or Sign Up now to post a comment!
Safety mode has hidden comments for this video. Show hidden comments
Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more