Forum Discussion

Giuliana1960's avatar
Giuliana1960
Copper Contributor
May 14, 2020

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 ...
Excel for web
Giuliana1960's avatar
Giuliana1960
Copper Contributor
May 18, 2020

tomrdillon1944 

 

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

mathetes's avatar
mathetes
Silver Contributor
May 19, 2020

Giuliana1960 

 

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?

Resources