Forum Discussion
Updating Sheet Name References after Changing Sheet Name
I do understand that when using sheet name references under normal circumstances, the formula does re-write itself if you change the sheet names. But you can see here that after I change the names to Feb, if I use the INDIRECT function to call the sheet references, the formula doesn't automatically change.
I've found a work around using find and replace, it should be all good now. Though if you have a simple solution that doesn't need find and replace, I'd be open to hearing it.
Tony_Nguyen Using three cells to lay out the date and then referencing with IFERROR and INDIRECT formulas combined would allow you to update the month, drag down and you’d have two clicks to update your references. You could use a singular month and year reference cell to the side as well so your down to one column for the day. Screenshots attached of how I was able to make this function. Additionally, if you use data validation to create a month list you can have it as simple as a dropdown for the month. I’m sure this won’t help OP but maybe someone else will get use of this!