View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
No Name
 
Posts: n/a
Default check book auto increment

Hi
I want to make a check book showing the following

date checkno Debit Credit Balance


Is it possible to move to the next line endlessly?
Like we drag the formula in last column and fill it vertically down .. lets
say 20 boxes.
I want that it should move to 21st row automatically without having the need
to fill in the formula.

the example is there in quick office, but I cant see how they made it,
formula is not visible.

Regards