In excel how do I increase a number in a cell by 1 after I print?

[Guest]

I use excel to print blank invoices for my company and i want that prints on
the invoice to go to the next higher number after everytime i print. any
suggestions?

 

[Gord Dibben]

Take a look at Ron de Bruin's site for adding a number to a cell each time a
copy is printed.

http://www.rondebruin.nl/print.htm#number


Gord Dibben MS Excel MVP

 

[Guest]

I need it in basic english because i have never used visual basic before.

 

[Peo Sjoblom]

http://www.mvps.org/dmcritchie/excel/install.htm

it doesn't get more basic than the above

 

[Gord Dibben]

Ron may be Dutch, but his website is in English.

If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the meantime..........

First...create a backup copy of your original workbook.

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + r to open Project Explorer.

Find your workbook/project and select it.

Right-click and Insert>Module. Paste Ron's code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run or edit the macro by going to Tool>Macro>Macros.

You can also assign this macro to a button or a shortcut key combo.


Gord