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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Numbering Sheets incrementally (as in Invoice numbers)
I would use John Walkenbach's SheetOffset function here
http://www.j-walk.com/ss/excel/tips/tip63.htm and I will include John's code that can be copied directly into a VBA module: Function SHEETOFFSET(offset, Ref) ' Returns cell contents at Ref, in sheet offset Application.Volatile With Application.Caller.Parent SHEETOFFSET = .Parent.Sheets(.Index + offset) _ .Range(Ref.Address).Value End With End Function In your first worksheet, put 1000 in cell J5, then select your other 31 sheets (hold down the control key and use the mouse to select all of the other sheets) and enter =sheetoffset(-1, J5)+1 in cell J5, which will be entered in all 31 sheets. Hit enter. For tutorials on navigating the VBA editor see David McRitchies site (The first two links are to the two tutorials that I think will help you the most, the third is the main page): http://www.mvps.org/dmcritchie/excel/install.htm http://www.mvps.org/dmcritchie/excel/getstarted.htm http://www.mvps.org/dmcritchie/excel/excel.htm "STEVE" wrote: 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. |
Reply |
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 |