Counting Number?

  • Thread starter Thread starter sidepocket
  • Start date Start date
S

sidepocket

Maybe I'm asking for too much, but I was looking into making a
spreadsheet that represents kind of an order form. But for that to
happen I'm going to need some sort of tracking number per form created,
hopefully in order :). Is there any way to do this or am I asking for
too much?
 
Sidepocket, you could use some VBA like this to add incress the number each
time you run it
Sheet1.[A1] = Sheet1.[A1].Value + 1
maybe before you print like this
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Sheet1.[A1] = Sheet1.[A1].Value + 1
End Sub

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Back
Top