Forum Discussion
Excel - Entering consecutive months in different sheets
I don't know how to auto fill that way but what I did in a similar application was to put a number in the a1 cell in each sheet going from 1 - 12 and then I was able to use formulas throughout the rest of the sheet accordingly (it is a workbook with timesheets for the whole year so it autogenerated the calendar for each month accordingly). I made my number 'invisible' by doing white text on white background but you could also hide the col / row or pick a different cell. (for example another application has the company logo located on each sheet and I just selected a cell behind the logo)
- Giuliana1960May 14, 2020Copper Contributor
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.
- mtarlerMay 14, 2020Silver Contributor
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)