Creating a shift Rota / Calendar

[bob230]

I am currently devising a rolling shift rota/calendar for a friend and his colleagues who work different shifts (Earlies, Lates and Nights).
I want to input an abbreviation/letter (for example 'N' for night-shifts) in a cell and then get excel to automatically repeat that same 'N' entry, every 28 days within the same row, but 28 columns away from the original entry.

Can anyone help please ?

Many Thanks, Bob230

 

[texasalynn]

so what is going to be repeating in the cells 28 columns away?

 

[bob230]

I would input the letter 'N' (abbreviation for Night-shift) in one cell, then the spreadsheet would automatically repeat the exact same cell content 'N', again 28 columns away. If I can get the formula for one repeating entry, then I can adapt it accordingly, enabling me to insert and complete the remaining shift variations of Days, Rest days etc that are at the 'X' number of days from each other, finally giving me a full working rota. If you can just help me to get the spreadsheet formula to repeat a duplicate entry - that will be great - many thanks

 

[texasalynn]

is this what you mean

Excel 2003
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
1	N																												N
Sheet1

Cell Formulas
Range	Formula
AC1	=+A1

 

[bob230]

is this what you mean
Excel 2003

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
N	N

<tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #E0E0F0"]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]AC1[/TH]
[TD="align: left"]=+A1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

[Not quite. I was hoping to use automated repeating formula - perhaps using the VBA programming language? - i'm not sure ]