Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sequential numbering when printing
Hi,
I am working on a regular excel spreadsheet that I need to print hundreds of. However, when i print the spreadsheet, they all need to be identical with the exception of the page number for reasons of record. I would like to have sequential numbering starting at 1....300, 301 and so on. Is there any way i can do this without having to use a macro or any type of code? I am not exactly good at any of that kind of thing. thanks, ryan l |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sequential numbering when printing
If you visit this site, though, JE gives two approaches to achieve
this (the text file approach may be better for you): http://www.mcgimpsey.com/excel/udfs/sequentialnums.html so you don't have to do much coding yourself. Hope this helps. Pete On Mar 20, 4:18*pm, wrote: Hi, I am working on a regular excel spreadsheet that I need to print hundreds of. *However, when i print the spreadsheet, they all need to be identical with the exception of the page number for reasons of record. *I would like to have sequential numbering starting at 1....300, 301 and so on. *Is there any way i can do this without having to use a macro or any type of code? *I am not exactly good at any of that kind of thing. thanks, ryan l |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sequential numbering when printing
Is it just one printed page and you want to print many copies of the same page?
See Ron de Bruin's site for macro code to do this. http://www.rondebruin.nl/print.htm#same If you're not familiar with VBA and macros, see David McRitchie's site for more on "getting started". http://www.mvps.org/dmcritchie/excel/getstarted.htm or Ron de De Bruin's site on where to store macros. http://www.rondebruin.nl/code.htm In the meantime.......... First...create a backup copy of your original workbook. To create a General Module, hit ALT + F11 to open the Visual Basic Editor. Hit CRTL + r to open Project Explorer. Find your workbook/project and select it. Right-click and InsertModule. Paste the code in there. Save the workbook and hit ALT + Q to return to your workbook. Run or edit the macro by going to ToolMacroMacros. You can also assign this macro to a button or a shortcut key combo. Gord Dibben MS Excel MVP On Thu, 20 Mar 2008 09:18:37 -0700 (PDT), wrote: Hi, I am working on a regular excel spreadsheet that I need to print hundreds of. However, when i print the spreadsheet, they all need to be identical with the exception of the page number for reasons of record. I would like to have sequential numbering starting at 1....300, 301 and so on. Is there any way i can do this without having to use a macro or any type of code? I am not exactly good at any of that kind of thing. thanks, ryan l |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sequential numbering | Excel Discussion (Misc queries) | |||
PO with sequential numbering with start / end numbering | Excel Discussion (Misc queries) | |||
Sequential Numbering | Excel Discussion (Misc queries) | |||
Sequential Numbering. | New Users to Excel | |||
Sequential numbering | Excel Discussion (Misc queries) |