File Name, Sheet Name: Easily Insert File Data in Excel!

There are many cases, in which you want to show the sheet name or file name in an Excel cell. Don’t worry, you don’t have to use VBA and create a macro. Excel provides a (rough) formula for returning all the information you need. The bad news: In most cases it takes some complex modifications. The… Continue reading File Name, Sheet Name: Easily Insert File Data in Excel!