You can use a formula like:
=mod(row(),8)+1
And you'll see a pattern like the one you want.

But you may have to adjust the starting point depending on what the first row
is:

=mod(row()+5,8)+1

If you don't get 1, try again <vbg.

Ripper wrote:

Is there a way to fill a repeating set of numbers. I have students listed by
their daily schedule. 1st period - 8th period. I want to create a period
column and have it fill in 1,2,3,4,5,6,7,8,1,2,3,4,5,6,7,8,1,2,3,4,5,6,7,8
all the way down the column to the last student. I tried fill series and
fill trend and even the fill handle to no avail.

Anyone know a trick other than copy and paste?
--
Thanks As Always
Rip

--

Dave Peterson