Forum Discussion
Excel - Entering consecutive months in different sheets
If I understand this you want 12 tabs, one for each month. Is this something you do frequently? Because if it's a one time setup then seems pretty easy to just create the separate tabs manually. If for some reason you do this all the time then easiest way is to just record a macro that does what you want done.
Yes, for now it is a one time only thing. I have created the twelve sheets and named them. In each sheet there is a field to put the name of the months, and I wanted it be updated automatically. I may not be even possible. I just saw the instructor doing it, and copied the function he used (=JANUARY!F1), but cannot make it work 😞
Thank you for responding,
Giuliana
FWIW, =JANUARY!F1 is not be a Function; rather it's simply a formula pointing to the F1 cell of a sheet named "January" and retrieving whatever value is in that cell, and placing it into the cell containing that formula. See the attached. You can change what's in cell F1 of the "JANUARY" sheet, and that value will appear in the yellow backgrounded cell of the next sheet.
What were you expecting it to do for you?
