how to repeat text on sheets in excel

K

Kmart57

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.
 
E

Elkar

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
 
U

ufo_pilot

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
 
Top