Nelson wrote...
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.
....

One more option. With a random integer from 1 to 49 in A1, use the
following formula in A2.

=MOD(A1,49)+1