View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gladys Gladys is offline
external usenet poster
 
Posts: 12
Default Auto Number Several Pages

I have a user who needs to autonumber a full page of continuous numbers.

Is there a way to auto fill rows and columns across.

Say page one column A we fill 1 - 55 in column B she need to start at 56 and
fill to 92. Then in column C fill 93....etc .Until the page is full - Up to
column "I" down to Row 55.

Then on Page 2 we start at Row 56 Column A and start with the next
sequential number. In this example it would be 351, and she needs to fill
that page with sequential numbers. She needs to have 70,000 numbers in
sequential order. Filling 8 1/2 x 11 paper.

Currently I have her just autofilling each column, any suggestions is
appreciated.

Thanks in advance.