Numbering printed pages

Scott-2013

New Member
Joined
Oct 27, 2013
Messages
1
Hello,

First off let me thank everyone who contributes to forums like this. It is so nice knowing that there are people out there willing to help when someone needs a hand...and on that note :eek:)

I have created a spreadsheet that I am using as a work order. I have a cell (C2) that contains the work order number...lets say it is WO-GV-0000.

Instead of taking these to a printer and paying a bunch to have them printed off, I'd like to print off 100 of them all at once and have the number increase by one each time...WO-GV-0001, WO-GV-0002 and so on.

I'm going to assume that this will be some kind of a VB or macro that will allow me to do this (if it's even possible).

Thank you in advance for any help you can provide.

Scott
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,108,950
Messages
5,525,822
Members
409,665
Latest member
Jessyi

This Week's Hot Topics

Top