View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Numbering Sheets incrementally (as in Invoice numbers)

With the least amount of keystrokes, how can I have a number that is typed in
cell J5 on 32 sheets in a workbook increase AUTOMATICALLY by one.
On the first sheet, I type 1000 in cell J5.
Automatically then I want cell J5 on sheet 2 to say 1001,
and so on up to 1032.

PLEASE GIVE ME EVERY STEP, since I have never entered a macro before,ie, I
don't know exactly where to enter it, how to save it, how to run it, etc.