On cell A2 type
=A1*(A1<49)+1
and fill all the way down and across


"Nelson" wrote in message
...
Hi there,

I have 6 columns across going 40 rows down. I'm entering random numbers
in
row 1 across columns A to F. The numbers have to stay in a range from 1
to
49 but are totally random in row 1. From rows 2 through 40 I want the
numbers to automatically fill down consecutively but not to exceed 49.
When
a certain column hits 49 I want that column to start over at 1 again.

I'm a total newbie when it comes to excel.

I did try entering A1+1 in cell A2 and then highlighting the remaining
rows
down to 40 in column A. I then went to the edit menu and choosing fill -
down. The problem here was that when I entered any number larger than 10
in
row 1 I would go over 49 somewhere down the column. I need the numbers to
start back at 1 when 49 is reached.

A B C D E F
Row 1 46 31 7 15 43 19
Row 2 47 32 8 16 44 20
Row 3 48 33 9 17 45 21
Row 4 49 34 10 18 46 22
Row 5 1 35 11 19 47 23
Row 6 2 36 12 20 48 24
Row 7 3 37 13 21 49 25
Row 8 4 38 14 22 1 26
Row 9 5 39 15 23 2 27


Thanks in Advance
Nelson