Just another play to try ..

Assume the starting number will be entered
in a cell outside the 6 C x 30 R table, say, in G1

Then we could populate the table
by placing in any starting cell, say, in A1:

=IF($G$1="","",$G$1+ROW(A1)*6-6+MOD(COLUMN(A1)-1,6))

and copy A1 across 6 cols to F1, fill down by 30 rows to F30
(or copy A1 down by 30 rows to A30, fill across 6 cols to F30)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"brbarto" wrote in
message ...

I would like to be able to enter a number in the first cell and have it
populate a table - 6 columns by 30 rows - incrementing each cell by
one.

For ex, if I enter 100 in the first cell, the rest of the row would be
101,102,103,104,105. The next row would be 106, 107, 108, 109, 110,
111. Etc.

Is there a easy way to do this?

Thanks,
Someone who rarely uses Excel


--
brbarto
------------------------------------------------------------------------
brbarto's Profile:
http://www.excelforum.com/member.php...o&userid=29755
View this thread: http://www.excelforum.com/showthread...hreadid=494773