View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
srctr srctr is offline
external usenet poster
 
Posts: 24
Default Numbering rows when printing

I want to be able to print a form and have certain rows be numbered when they
print. For example the first time I print it I may print 2 copies and I want
rows 5 thru 24 to number on the 1st page 1-20, 2nd page 21-40, etc. If I
need to print again this time I want the rows to be numbered 41-60. It is an
sign up sheet and we need to have a unique sheet that keeps a running tally.

I would like this instead of creating one long worksheet with all the rows
numbered from 1 thru 300. I suspect it would be a macro where I would have
to enter at least the beginning row number.

Thanks for any help
--
cao