I am using the Today() calculation to show the current month in worksheet titles. I am trying to ensure that I don't have to go into each sheet every month and update the month manually. The title reads this:
<Sheet Name> - <MONTH(Today)>
Some worksheets have activity for the month. The title reads:
Sheet Name - October 2016
Some worksheets don't have activity for the month. The title reads:
Sheet Name - All
Is there a workaround for this? The first sheet always has data in it. Could I create a relationship with another sheet or data source in the workbook so that the data read off of that instead of coming up blank?