00:00If you use Excel a lot, you're probably going to want to watch this.
00:03Having your dataset title after the worksheet name helps distinguish between worksheets easily,
00:08but updating the worksheet name requires manual title adjustment,
00:12which can be solved using an automated technique.
00:15And here's how you do it.
00:16We start off with using a cell function, and for the very first argument,
00:20we are allowed to set the various info types.
00:23The one that we are particularly interested would be the file name.
00:27This formula retrieves the entire path and the file name of the present Excel workbook.
00:33We are solely interested on the final segment, which denotes the worksheet name.
00:37Well, to isolate the worksheet name, we employed the text after function
00:42with the closing square bracket as the delimiter.
00:46Well, let's proceed with that approach.
00:48And now, if we change the worksheet name, the title automatically updates accordingly.
00:58We'll see you next time.
