Consecutive Numbering

[Greg25]

I have a pre-printed form and would like to print Consecutive Numbers on the forms

word excel or access

and how would this be acomplished

any help would be great Greg
X-)

 

[JVFriederick]

Excel
Use blank paper in the printer, and arrange the spreadsheet to print a number in the font and location desired. Use a light table or an outside window pane to overlay the printout with the pre-printed form.

Assume the cell with the number (that prints out correctly) is located in E10 after you have adjusted rows and column widths. Now create the following macro code :

Sub PrintPagesNow()
For PageCount = 1 To 8 ' will print 8 pages consecutively
ActiveWindow.SelectedSheets.PrintOut Copies:=1
CurrentCount = ActiveSheet.Rows(10).Columns(5) ' Get the value from E10
ActiveSheet.Rows(10).Columns(5) = CurrentCount + 1 ' Store new value to E10
Next PageCount


It's really not as bad as it may "read". I previously did this all the time for explosives inventory and equipment maintenance sheets.

 

[Greg25]

thanks i will look into this more
Greg
X-)

 

[Greg25]

for got to metion i know nothing about excel Greg
X-)

 

[JVFriederick]

NOW you tell me !!

Looks like you may be learning it ....... or delegating !!

 

[Greg25]

Thank s for the info
looks like i will do a
mail merage
from excel to word
did some test it seems
to work
Thanks Greg
X-)

 

[AidanEnos]

wow was that ever complicated....

open a new spreadsheet

in cell A1 put the first number you want
select the number of cells you want numbered

1.

Edit
Fill
Series
Make sure the Step value is at 1, and it's a linear growth then hit ok.

You can do this with any number or alpha numeric combination, and in any steps (like every 14.3 for the step value) - it's fast and easy and what Excel was made to do )

AidanEnos

 

[JVFriederick]

AidanEnos
Re-read the original post.
The consecutive values must be printed on existing published forms.

 

[AidanEnos]

I read his request differently, your reply gives him numbered pages, mine gives him a list of consecutive numbers down a section of the page. I'm assuming there is a list somewhere on the page that he wants to number the lines - but his request is unclear.

Didn't mean to stomp over your parade - I didn't even read your response fully the first time I posted because he didn't ask how to do page numbers... I'd just tell him to us MS Word Edit header, Page [&page] of [&pages] then hit file, print pages 1-20 or however many page numbers he wants.

Sorry to come off offensive, I didn't want to create conflit, just offer a simple answer depending on what he was really asking for.

AidanEnos

 

[JVFriederick]

No stomping inferred. Sorry if it read that way.

A secretary of mine used to run final reports through Wordperfect all the time to renumber the completed document after all charts, maps, and drawings had been finalized.

I would have suggested Word but didn't know if Greg25 would get complete control over the placement onto the preprinted forms as easily as Excel. Well, at least for me !!

 

[AidanEnos]

Placement in Word....

Just put what you want in a text box then drag it wherever you want it )