Hello. I am teaching myself intermediate Excel and I have a question. I will describe the scenario.

I have one workbook with 12 sheets. I want to place a month in text form in cell A2 of each sheet. For example, January in the first sheet, February in the second sheet, etc. I have grouped the worksheets.

I would like to know if there is a way to place a date formula in the first worksheet (where January would be entered) so that each subsequent sheet would automatically have the appropriate text date (January, February, March, etc.), so that I would not have to type each separate month in each of the 12 sheets.



Thank you.

You are trying (in your thought process) to push the data out to the other sheets. That is not possible. You need to pull the data and manipulate it.

You need to have the date in A2 in your first sheet. On the subsequent sheets you use the formula
Sheet 2: =EOMONTH(Sheet1!A2;0)+1
Sheet 3: =EOMONTH(Sheet2!A2;0)+1
etc.

Or alternatively

Sheet 2: =EOMONTH(Sheet1!A2;0)+1
Sheet 3: =EOMONTH(Sheet1!A2;1)+1
etc.

Then you change the format (right-click on each cell and choose properties) to "custom" and enter mmmm as the format.

/Møller

Why do you need one sheet per month?

In XL it's always easier to use a range on one sheet and extract monthly data later

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you for your response, c991257.

You welcome. Please remember to mark the thread as solved.


/Møller