Excel sequential numbering

[seedubya]

Hi all,

I've designed a new worksheet in excel. I want to print, say, 20 copies and have them sequentially numbered (in a particular place) and have the numbers start at a number of my choice.

If anyone knows how to do this I'd appreciate it.

TIA

 

[LunchBox]

Its been a while since I had to mess around with excel. I am not sure where you want the number, have you look at adding the numbering as a footer?

Most likely if the above is not what you need, then you will need to make a macro. I have to print reports and I got tired of always typing the name of the person along with whatever information they wanted. I created a macro that when I would pick the name of the recipient it would choose the columns, sort it their way, number pages, print and a few other things that I cant remember now.

I think you will have to give a bit more information.

 

[seedubya]

The number needs to go in a cell on the worksheet and beyond that I don't see what extra info I can provide. I just want to print them. This would be easy in Word

 

[LunchBox]

I an not sure if this is what you need but here it goes.
My example

Lets say Cell A1 starts with number 15 and you want to go to cell A25 and number each cell so it would be A1=15 A2=16 and so on

If this is what you are referring to then on the first cell you want the number on the bottom right corner "right" click and while holding the click move the mouse down to cell A25 (per the example). A menu will come up so select series, now a box will come up. Just click ok and leave the selection as is.

You should now see your selection numbered starting with the chosen number. You can do this with days, years etc.

Hopefully this is what you are looking for

Oh and I am using Office 2003

 

[seedubya]

Sorry - I've obviously not explained myself properly. What you're explaining I could do with my eyes closed - no offense intended. What I'm trying to do is print a different number on each copy of the document that I print.

 

[TimeCode]

To further clarify... I think he means that on an invoice, he has an invoice number. He wants that number to start at 1001 and print out 20 copies. On the 20th copy, that same cell should print out 1020.

@CW, is that what you mean?

 

[LunchBox]

How about this link? I got busy so I did not get a change to test it out.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

 

[seedubya]

Thanks Tim. My original explanation was terrible.
LunchBox - thanks, however that appears to be a macro to make the invoice number increment by one every time you SAVE a copy. It would work but would be incredibly cumbersome.

 

[LunchBox]

Maybe one of the other techs here can help with specifically coding it.

Its been a while for me. I will take sometime and see about making it work. Once I get to that point I can give you steps on how to create the macro or I can upload the file which would require less on your end (in case you dont know how to do macros). Once its working though it will not require any maintenance from you end.

 

[TimeCode]

Thanks Tim. My original explanation was terrible.

Any time. I just wish I had the answer for you.