Forum Discussion
Excel - Entering consecutive months in different sheets
I'm working with a worksheet that would have 12 different sheets, one for each month. I'd like to type January on the first worksheet, and for the other 11 months to fill automatically in the other ...
Thank you. Did you numbered the a1 cell in each sheet automatically? What I had written down is the following =JANUARY!F1 (which I'm assuming is the cell where the initial value is), but I may not be applying it correctly.
Giuliana1960 no, as I mentioned I did not autofill or autocalculate. I just manually set the A1 cell in each sheet. Then in B1 I used a formula like =TEXT(DATE(2020,A1,1),"MMMM") to show the Month in text format. (I actually have a cell where I define the year for the whole workbook but that is something else)