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...
No guarantees, but it may be possible to use 3D ranges. For example, if cell A1 contains the sheet name
sheetName
=Apr:Jun!$A$1
revenue
=Apr:Jun!$F$45then
= TOCOL(sheetName)
= TOCOL(revenue)
= SUM(revenue)would be a list of the months taken from the sheet names, the revenue for each month and the total revenue respectively. And not a direct cell reference to be seen!
