Andy W
|
| posted on 24/9/10 at 05:42 PM |
|
|
Excel Help
Hi
I've got a one page excel document, basically it's a one sheet form. I need to print about 100 copies each individually numbered. I know
if the form was 100 pages in total I could easily auto number each printed page. Does anyone know a way to do this, I've spent a bit of time
searching google and whilst it seems possible, it looks as though you need to write some code?? which seems a bit beyond my excel skills.
Thanks Andy
|
|
|
|
|
Agriv8
|
| posted on 24/9/10 at 06:12 PM |
|
|
not sure if it will work but I would cheat.
Install a Free PDF printer eg cute pdf then print 100 copies to the PDF printer. then when you print the 100 pages to your proper printer you should
be able to switch on ' Print Page numbers '
option 2 if the form is not too complicated patse it into word ans do a simple mail merge for your page number
regards
agriv8
Taller than your average Guy !
Management is like a tree of monkeys. - Those at the top look down and see a tree full of smiling faces. BUT Those at the bottom look up and see a
tree full of a*seholes .............
|
|
|
austin man
|
| posted on 24/9/10 at 06:15 PM |
|
|
not really up on it just had a look at print preview and ther is a box that says first page number I wonder if you put a 1 in if it will
automatically number from there worth a try at setting it to 1 and printing 4 pages to see if they do get numbered
Life is like a bowl of fruit, funny how all the weird looking ones are left alone
|
|
|
bmseven
|
| posted on 24/9/10 at 06:29 PM |
|
|
As above - Excel does it for you
Print Preview - Custom Footer
then click on the page number format you require
eg Page 1 etc or Page 1 of XX
BMW 7 Resource
Bures Pit anyone?
|
|
|
Litemoth
|
| posted on 24/9/10 at 06:37 PM |
|
|
You're going to need a bit of code....
Written for you here:
LINKY
|
|
|
gingerprince
|
| posted on 24/9/10 at 06:44 PM |
|
|
The header idea will just print "1" 100 times. Try this instead: -
Put "1" in a cell somewhere on your worksheet where you'd like the page number to be. Then create the following macro (substitute
A1 for wherever your number should go): -
For i = 1 To 5
Range("A1" .Value = i
ActiveWindow.SelectedSheets.PrintPreview
Next i
Run it and you'll get 5 print previews, which hopefully look like you want.
When you're happy, change 5 to 100 and PrintPreview to PrintOut.
Bish bash bosh, bob's your dog.
|
|
|
Andy W
|
| posted on 24/9/10 at 07:00 PM |
|
|
Hi
Thanks for the replys, when I started started this afternoon I thought it would be simple. I'll try creating the macro, never done any before
though. I found some info on code's earlier today, is that were you use alt f11? that's as far as I got, I need step by step instructions
to follow that.
Andy
cheers Andy
|
|
|
gingerprince
|
| posted on 24/9/10 at 07:02 PM |
|
|
Tools...Macro...Macros...
Type a name (anything)
Click Create
Paste the code
Press the Play button
Simples 
quote:
Originally posted by Andy W
Hi
Thanks for the replys, when I started started this afternoon I thought it would be simple. I'll try creating the macro, never done any before
though. I found some info on code's earlier today, is that were you use alt f11? that's as far as I got, I need step by step instructions
to follow that.
Andy
cheers Andy
|
|
|
Andy W
|
| posted on 24/9/10 at 07:59 PM |
|
|
Hi
Thanks for the help, I basically understand what I have to do now, just can't get it to work. Keep getting errors
Andy
|
|
|
.jpg)
