Newbie here that needs help!

  • Thread starter Thread starter fords8
  • Start date Start date
F

fords8

Hi everyone. I am new to the forum and new to using Excel.

I have a invoice that I am working on and it has a invoice #. I want
that # to count up as I save and print the invoices.

So if I am working on invoice # 100 and I save and print it. I want the
next invoice to have the # 101. And so on. Thanks!
 
Use the before print event in the ThisWorkbook vba module

I would do that if I knew what it was.
 
Right click on the excel icon in the upper left next to FILE>click on view
code>in the left window select workbook>in the right window select before
print
within the macro type

range("a1").value=range("a1")+1
 
Cool thanks it worked.

Now I need the invoice togo to blank state. I want the name, address,
city, state, zip, Description, prices, and totals blank so I can do my
next invoice. I want it to have the next invoice #, but be ready for
the next order. When I print it, is there a way to make that invoice I
just printed to save automanticly to a folder? That way if I need togo
back to it if I need too.

Thanks again!
 
One way would be to use an workbook_open event found in the same place and
have it

range("a2,b3,c4").clearcontents
 
Back
Top