Help!

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

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users RSS
Next:  How do I shade a cell if its blank?  
Author Message
mjtaxpro
External


Since: Jul 26, 2007
Posts: 2



PostPosted: Thu Jul 26, 2007 3:44 pm    Post subject: In excel how do I increase a number in a cell by 1 after I print?
Archived from groups: microsoft>public>excel>newusers (more info?)

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?
Back to top
Gord Dibben
External


Since: Feb 23, 2004
Posts: 9431



PostPosted: Thu Jul 26, 2007 4:32 pm    Post subject: Re: In excel how do I increase a number in a cell by 1 after I print? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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?
Back to top
mjtaxpro
External


Since: Jul 26, 2007
Posts: 2



PostPosted: Thu Jul 26, 2007 4:50 pm    Post subject: Re: In excel how do I increase a number in a cell by 1 after I pri [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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?
>
>
Back to top
Peo Sjoblom
External


Since: Sep 15, 2003
Posts: 2970



PostPosted: Thu Jul 26, 2007 4:54 pm    Post subject: Re: In excel how do I increase a number in a cell by 1 after I pri [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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?
>>
>>
Back to top
Gord Dibben
External


Since: Feb 23, 2004
Posts: 9431



PostPosted: Thu Jul 26, 2007 7:36 pm    Post subject: Re: In excel how do I increase a number in a cell by 1 after I pri [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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


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?
>>
>>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum