| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SET UP AUTOMATIC INVOICE NUMBERS | Excel Discussion (Misc queries) | |||
| How do I set up an automated numbering system For my "Invoice Num | Excel Worksheet Functions | |||
| Numbering sheets in workbook | Excel Worksheet Functions | |||
| invoice numbering | Excel Worksheet Functions | |||
| Invoice numbers? | Excel Worksheet Functions | |||
Threaded Mode
