how to repeat text on sheets in excel

[Guest]

For my groups vacation schedule, I would like to the names to remain on
sheet A then the months of the year start on sheet B but display the
names from sheet A.
I thought I saw this done somewhere but cannot locate it.
Any other methods of planning vacation time for employees would be
appreciated.

 

[Guest]

To reference a cell on a different sheet, use this formula:

='Sheet A'!A1

This pulls the contents of cell A1 on the sheet named 'Sheet A'

HTH,
Elkar

 

[Guest]

Or:
=IF(Sheet1!A1<>"",Sheet1!A1,"")
will not leave you any zero's for blank cells it is reading
this can be copied onto other cells