how to create a folio printing dependable number

Chiwascrazy2

New Member
Joined
Feb 25, 2009
Messages
1
I need to create a file with a priinting copies dependable number ( a folio ) in a file to identify only one number to an crated hard fomat that every time that printed is changed to the actual one increasing by 1 in each of the printed copies.
thanks in advance for the help
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Oorang

Well-known Member
Joined
Mar 4, 2005
Messages
2,071
AFAIK Excel does not have that feature. You can fake it with vba though:
Code:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
    Sheet1.Cells(1, 1).Value = Sheet1.Cells(1, 1).Value + 1
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,102,551
Messages
5,487,522
Members
407,604
Latest member
sama9000

This Week's Hot Topics

Top