Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Number Several Pages
Well, an easy way around this is, if A1 is 1, make A2 =A1+55, then copy A2
down your rows and across your columns. Autofill your 2 - 55 across row 1, and it should all populate for you... "Gladys" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Number in Invoice | New Users to Excel | |||
Trying to do a auto number generater | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
How do I add an auto number to a worksheet | Excel Discussion (Misc queries) | |||
assign auto number and auto date | Excel Discussion (Misc queries) |