Forum Discussion
Worksheet names in cells so that when I change the cell, formulas based off it change
Hey everyone, I am working on a project where every month I will get new financials. I would like to set up my worksheet to be dynamic so if I change the cell L2 from "P&L Company 2021 DEC" to "P...
Hey Hans,
Thanks for the response. Is there a way I can reference the entire sheet with this formula? I basically want to do a lot of reporting using index match, and want to use this in various index match formulas without having a different indirect formula each time.
Thanks for the response. Is there a way I can reference the entire sheet with this formula? I basically want to do a lot of reporting using index match, and want to use this in various index match formulas without having a different indirect formula each time.
Perhaps an easier option is to leave the formulas as they are now, and to use the Replace dialog to change the sheet name in all formulas.
HansVogelaar I was thinking so too but then the only issue is the data always compares month over month so if I replace all Jan references in February, I will lose the previous month formulas
Referring to your screenshot: if you first replace P&L Company 2022 JAN in formulas with P&L Company 2022 FEB, and then replace P&L company 2021 DEC with P&L Company 2022 JAN, you'll be comparing February '22 with January '22 instead of January '22 with December '21.