Forum Discussion
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 ide...
I can think of two possibilities here. The most obvious and simplest is to use the search and replace dialogue.
Search '=May!'
Replace '=June!'
Search in formulas must be switched on.
Or you can rebuild your formulas and use the INDIRECT() function=
=INDIRECT(Y1&"!A1")Then you get =June!A1 if cell Y1 contains the word 'June'.
