How do I create incremental numbers on an order form?
 

I am attempting to create an order form with incremental order numbers. When
I print a number of pages I would like each page to have a new number,
increased by 1, from the page before.

What do you mean "Pages"? You can add page numbers to your headers or
footers by hitting View--Header and Footer.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Mark" wrote in message
...
I am attempting to create an order form with incremental order numbers.
When
I print a number of pages I would like each page to have a new number,
increased by 1, from the page before.

Unlike page numbers I need to print out 50 copies of the same page. Each
order form would have a different number; 001, 002, 003, etc.

"Anne Troy" wrote:

What do you mean "Pages"? You can add page numbers to your headers or
footers by hitting View--Header and Footer.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Mark" wrote in message
...
I am attempting to create an order form with incremental order numbers.
When
I print a number of pages I would like each page to have a new number,
increased by 1, from the page before.

OIC!!
Hm.... I'll leave this one to the VBA coders. :)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Mark" wrote in message
...
Unlike page numbers I need to print out 50 copies of the same page. Each
order form would have a different number; 001, 002, 003, etc.

"Anne Troy" wrote:

What do you mean "Pages"? You can add page numbers to your headers or
footers by hitting View--Header and Footer.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Mark" wrote in message
...
I am attempting to create an order form with incremental order
numbers.
When
I print a number of pages I would like each page to have a new number,
increased by 1, from the page before.

Do you want the page numbers placed in a cell?

If yes, you could run a macro that prints the 50 copies:

Option Explicit
Sub testme01()
Dim iCtr As Long
With Worksheets("sheet1")
With .Range("a1")
.NumberFormat = "000"
For iCtr = 1 To 50
.Value = iCtr
.Parent.PrintOut preview:=True
Next iCtr
End With
End With
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Mark wrote:

Unlike page numbers I need to print out 50 copies of the same page. Each
order form would have a different number; 001, 002, 003, etc.

"Anne Troy" wrote:

What do you mean "Pages"? You can add page numbers to your headers or
footers by hitting View--Header and Footer.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Mark" wrote in message
...
I am attempting to create an order form with incremental order numbers.
When
I print a number of pages I would like each page to have a new number,
increased by 1, from the page before.




--

Dave Peterson