Forum Discussion
changing sheet reference
I have a workbook with one specific sheet (X) that populates a roster from another sheet (Y) that has all employees locations throughout the month. I'm wondering if there is a way to get it to auto r...
You could use INDIRECT to point to the correct monthly sheet based on the current month. A simple example of referring to A1 on the November sheet:
=INDIRECT(TEXT(TODAY(),"mmmm")&"!A1")
Depending on the arrangement of the workbook and the version of Excel you're running, it might be wiser to forego INDIRECT to 'stack' all monthly data and then simply pull the month you need.