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

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?

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

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


On Thu, 26 Jul 2007 11:44:11 -0700, mjtaxpro
wrote:

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?

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

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


"Gord Dibben" wrote:

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


On Thu, 26 Jul 2007 11:44:11 -0700, mjtaxpro
wrote:

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?

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

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

it doesn't get more basic than the above


--
Regards,

Peo Sjoblom



"mjtaxpro" wrote in message
...
I need it in basic english because i have never used visual basic before.


"Gord Dibben" wrote:

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


On Thu, 26 Jul 2007 11:44:11 -0700, mjtaxpro
wrote:

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?

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

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 InsertModule. 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 ToolMacroMacros.

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


Gord


On Thu, 26 Jul 2007 12:50:04 -0700, mjtaxpro
wrote:

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


"Gord Dibben" wrote:

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


On Thu, 26 Jul 2007 11:44:11 -0700, mjtaxpro
wrote:

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?