Can I change just the sheet, but keep the cells in multiple references
I have a workbook that tracks data in monthly tabs. I also have a sheet that pulls multiple datapoints from each worksheet for an easily printable report.
Since each of the monthly sheets is identical, is there a way that, as I go into a new month, I can change just which sheet my report pulls from, but keeps the cell references?
For example if I have data pulling from =May!A1 , =May!C3, =May!F45, is there an easy way to change all of the Mays to Junes?
Thanks in advance.
I have a workbook that tracks data in monthly tabs. I also have a sheet that pulls multiple datapoints from each worksheet for an easily printable report. Since each of the monthly sheets is identical, is there a way that, as I go into a new month, I can change just which sheet my report pulls from, but keeps the cell references? For example if I have data pulling from =May!A1 , =May!C3, =May!F45, is there an easy way to change all of the Mays to Junes? Thanks in advance. Read More