A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel Invoice followon autonumbering



 
 
Thread Tools Display Modes
  #1  
Old May 25th, 2010, 09:53 PM posted to microsoft.public.excel.newusers
cjw064
external usenet poster
 
Posts: 11
Default Excel Invoice followon autonumbering

Hi
Can anybody help me please I have designed an invoice, I want it to assign a
new invoice number everytime a new invoice is generateded.
Please could somebody give me an answer in clear jargon free wording, as I
am really new to excel and I havent got a clue what I am doing.
Many thanks,
Chris
  #2  
Old May 26th, 2010, 02:13 PM posted to microsoft.public.excel.newusers
Otto Moehrbach[_2_]
external usenet poster
 
Posts: 716
Default Excel Invoice followon autonumbering

Chris
This is pretty simple except for one thing. What constitutes "a new
invoice is generated"? Excel can react automatically to many "events" and
do whatever you want when the "event" occurs. So when do you want the new
number assigned? Maybe when a specific cell gets an entry? Maybe when you
print the invoice? Maybe something else? HTH Otto

"cjw064" wrote in message
...
Hi
Can anybody help me please I have designed an invoice, I want it to assign
a
new invoice number everytime a new invoice is generateded.
Please could somebody give me an answer in clear jargon free wording, as I
am really new to excel and I havent got a clue what I am doing.
Many thanks,
Chris


  #3  
Old May 26th, 2010, 05:19 PM posted to microsoft.public.excel.newusers
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Excel Invoice followon autonumbering

Is your Invoice workbook a true Template(*.xlt) or just a copied sheet?

As Otto points out..........when do you want the number incremented?

I will point you to JE McGimpsey's site for some code to generate a new
number when workbook is opened.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Post back for more assistance if required.


Gord Dibben MS Excel MVP

On Tue, 25 May 2010 13:53:01 -0700, cjw064
wrote:

Hi
Can anybody help me please I have designed an invoice, I want it to assign a
new invoice number everytime a new invoice is generateded.
Please could somebody give me an answer in clear jargon free wording, as I
am really new to excel and I havent got a clue what I am doing.
Many thanks,
Chris


  #4  
Old May 27th, 2010, 10:11 PM posted to microsoft.public.excel.newusers
cjw064
external usenet poster
 
Posts: 11
Default Excel Invoice followon autonumbering

Hi Otto and Gord,

Many thanks for replying... what I basically want to happen is, I have
generated a self made invoice template, I want it to for example open and
start at #1 I then write the invoice and save it to my customers file. i then
need to produce another invoice and its becomes #2 and so on...

Hope that makes sence

Chris )

"Otto Moehrbach" wrote:

Chris
This is pretty simple except for one thing. What constitutes "a new
invoice is generated"? Excel can react automatically to many "events" and
do whatever you want when the "event" occurs. So when do you want the new
number assigned? Maybe when a specific cell gets an entry? Maybe when you
print the invoice? Maybe something else? HTH Otto

"cjw064" wrote in message
...
Hi
Can anybody help me please I have designed an invoice, I want it to assign
a
new invoice number everytime a new invoice is generateded.
Please could somebody give me an answer in clear jargon free wording, as I
am really new to excel and I havent got a clue what I am doing.
Many thanks,
Chris


.

  #5  
Old May 27th, 2010, 11:49 PM posted to microsoft.public.excel.newusers
Otto Moehrbach[_2_]
external usenet poster
 
Posts: 716
Default Excel Invoice followon autonumbering

Chris
As I said before, Excel needs to know when to increment the number.
Let's work on that only for now. You say you "save it to my customers file".
That might be an event we can use. Exactly what do you do when you "save it
to my customers file". Don't generalize. Tell me "I hit this key", "I
click on that button", etc, etc, etc. Otto

"cjw064" wrote in message
...
Hi Otto and Gord,

Many thanks for replying... what I basically want to happen is, I have
generated a self made invoice template, I want it to for example open and
start at #1 I then write the invoice and save it to my customers file. i
then
need to produce another invoice and its becomes #2 and so on...

Hope that makes sence

Chris )

"Otto Moehrbach" wrote:

Chris
This is pretty simple except for one thing. What constitutes "a new
invoice is generated"? Excel can react automatically to many "events"
and
do whatever you want when the "event" occurs. So when do you want the
new
number assigned? Maybe when a specific cell gets an entry? Maybe when
you
print the invoice? Maybe something else? HTH Otto

"cjw064" wrote in message
...
Hi
Can anybody help me please I have designed an invoice, I want it to
assign
a
new invoice number everytime a new invoice is generateded.
Please could somebody give me an answer in clear jargon free wording,
as I
am really new to excel and I havent got a clue what I am doing.
Many thanks,
Chris


.

  #6  
Old May 28th, 2010, 01:48 AM posted to microsoft.public.excel.newusers
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Excel Invoice followon autonumbering

You are saying the invoice template is a real Template(*.xlt) or (*.xltx)
and not just a copied sheet?

In that case see McGimpsey's site.


Gord


On Thu, 27 May 2010 14:11:23 -0700, cjw064
wrote:

Hi Otto and Gord,

Many thanks for replying... what I basically want to happen is, I have
generated a self made invoice template, I want it to for example open and
start at #1 I then write the invoice and save it to my customers file. i then
need to produce another invoice and its becomes #2 and so on...

Hope that makes sence

Chris )

"Otto Moehrbach" wrote:

Chris
This is pretty simple except for one thing. What constitutes "a new
invoice is generated"? Excel can react automatically to many "events" and
do whatever you want when the "event" occurs. So when do you want the new
number assigned? Maybe when a specific cell gets an entry? Maybe when you
print the invoice? Maybe something else? HTH Otto

"cjw064" wrote in message
...
Hi
Can anybody help me please I have designed an invoice, I want it to assign
a
new invoice number everytime a new invoice is generateded.
Please could somebody give me an answer in clear jargon free wording, as I
am really new to excel and I havent got a clue what I am doing.
Many thanks,
Chris


.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:54 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.