Excel 2000 Page Numbering?!?!?!?!?

[phlyx]

I have an Excel spread sheet for a form that we are going to print out for people to manually fill in. There is a cell on this form that contains a item number that everything else that manually gets filled in relates to. I want to print out (for example) 100 copies of the form and I would like to be able to sequence this number on each printed copy. For example the first (master) form has 1001 in the cell. If I print several copies I want to have the printed copy show 1001, 1002, 1003, 1004... etc. I can do this similar thing with a Word doc by using mail merge but I cannot find a way to do it in Excel.

Any ideas?!?!?!?!

 

[AJ]

Hiya,
Not sure if this will help, but if you had a macro to do the printing, then you could increment the value in that cell each time it prints. For example, if your value was in Cell A1, then:

For i = 1 To 100
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Range("A1").Value = Range("A1").Value + 1
Next i

Hope this helps
AJ

 

[Jack in the UK]

Hi

I send letters to billions of people and im lazy so yes this kind of thing can be done all in Excel, like merge from data table... via template in same wkbk.. save files as unique name and so on...

can be done... any good