Formulas for tracking numbers
 

IS there ANYONE who knows how to make a formula or a process that can make
tracking numbers 4 to a page down not across a cut 1/4 stack ?
That means once i cut a pile of 8.5x11 sheets in 4 quarters.. each stack is
numericly in order .

Because so far i been posting this question in MS Office help ..NOT 1 soul
CAN figure this out !! WHAT gives??

Formulas for tracking numbers
 

Hi James,

Am I interpreting your request correctly in that you want to cut 4 sheets
8.5 x 2.75 from each sheet?

If above is correct then if you have 200 full sheets then the top quarter of
the first full sheet will be page 1, second quarter page 201, third quarter
page 401 and fourth quarter page 601.

Therefore the first quarter of each sheet will be consecutive 1 to 200.
Second quarter of each sheet will be first quarter number + 200
Third quarter will be first quarter number + (200 x 2)
Fourth quarter will be first quarter number + (200 x 3)

I cant give you a specific formula which will return all the answers in one
formula; only a separate formula for each quarter. Replace 200 in each of the
above with the number of full sheets.

If I have not provided the answer then perhaps you need to explain in more
detail what you require.

--
Regards,

OssieMac


"james" wrote:

IS there ANYONE who knows how to make a formula or a process that can make
tracking numbers 4 to a page down not across a cut 1/4 stack ?
That means once i cut a pile of 8.5x11 sheets in 4 quarters.. each stack is
numericly in order .

Because so far i been posting this question in MS Office help ..NOT 1 soul
CAN figure this out !! WHAT gives??

Formulas for tracking numbers
 

Yes that wa sok eccept that, it didnt tell me HOW to create that in excel,
something i didnt know.


"OssieMac" wrote:

Hi James,

Am I interpreting your request correctly in that you want to cut 4 sheets
8.5 x 2.75 from each sheet?

If above is correct then if you have 200 full sheets then the top quarter of
the first full sheet will be page 1, second quarter page 201, third quarter
page 401 and fourth quarter page 601.

Therefore the first quarter of each sheet will be consecutive 1 to 200.
Second quarter of each sheet will be first quarter number + 200
Third quarter will be first quarter number + (200 x 2)
Fourth quarter will be first quarter number + (200 x 3)

I cant give you a specific formula which will return all the answers in one
formula; only a separate formula for each quarter. Replace 200 in each of the
above with the number of full sheets.

If I have not provided the answer then perhaps you need to explain in more
detail what you require.

--
Regards,

OssieMac


"james" wrote:

IS there ANYONE who knows how to make a formula or a process that can make
tracking numbers 4 to a page down not across a cut 1/4 stack ?
That means once i cut a pile of 8.5x11 sheets in 4 quarters.. each stack is
numericly in order .

Because so far i been posting this question in MS Office help ..NOT 1 soul
CAN figure this out !! WHAT gives??