Hi I have to create an excel sheet that has the following details.

1. numbers ranging from 06-0001 to 06-8000
2. The number at the bottom of column A on page 1 must continue at the
top of column C on page 1.

I tried doing this with the row() function but I think it will take me
about a year to enter it all as I have to restart at the top of each
column and add the number from the bottom of the previous column.

I also tried dragging the box, but that was equally tedious. I am
hoping there is a better way?

I think this might be confusing so I will do my best to illustrate what
I need.
Page 1
A B C D E F G H
06-0001 Blank 06-0048 Blank
... ... 06-0049 Blank
... ... ...
... ... ...
06-0047 Blank

this pattern would continue until the 06-8000 number is reached. With
the last number of column G increasing by one for the first number in
column a on page 2. 8 columns per page.

Thanks for looking.


--
Seveneleven
------------------------------------------------------------------------
Seveneleven's Profile: http://www.excelforum.com/member.php...o&userid=30954
View this thread: http://www.excelforum.com/showthread...hreadid=506222