how to repeat text on sheets in excel
 

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.

how to repeat text on sheets in excel
 

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


"Kmart57" wrote:

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.

how to repeat text on sheets in excel
 

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


"Elkar" wrote:

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


"Kmart57" wrote:

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.