Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Allan
 
Posts: n/a
Default increment invoice numbers in excel

I have just setup an 'order' template in excel and inserted a macro that
increments the number when opened.
I have tested the workbook and I now wish to reset thenumbering system back
to 0 (zero).
Can anyone advise me how I proceed.
Allan
  #2   Report Post  
Paul B
 
Posts: n/a
Default

Allan, where every you are storing the number in the macro just change it
back to to 0 there

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Allan" wrote in message
...
I have just setup an 'order' template in excel and inserted a macro that
increments the number when opened.
I have tested the workbook and I now wish to reset thenumbering system

back
to 0 (zero).
Can anyone advise me how I proceed.
Allan



  #3   Report Post  
Allan
 
Posts: n/a
Default

Hi Paul
The trouble is I do not know where it is being saved.
This is the macro can you tell me where I find the place to reset the number;
With .Range("I6")
If IsEmpty(.Value) Then
nNumber = GetSetting(sAPPLICATION, sSECTION, sKEY,
nDEFAULT)
.NumberFormat = "@"
.Value = Format(nNumber, "0000")
SaveSetting sAPPLICATION, sSECTION, sKEY, nNumber + 1&
Cheers. Allan
"Paul B" wrote:

Allan, where every you are storing the number in the macro just change it
back to to 0 there

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Allan" wrote in message
...
I have just setup an 'order' template in excel and inserted a macro that
increments the number when opened.
I have tested the workbook and I now wish to reset thenumbering system

back
to 0 (zero).
Can anyone advise me how I proceed.
Allan




  #4   Report Post  
Paul B
 
Posts: n/a
Default

Allen, not sure without seeing all the code but you could try to make
nNumber = 0 and see if that will work, something like this, just put in a 0
and a ' after it to comment out the rest.
nNumber = 0 'GetSetting(sAPPLICATION, sSECTION, sKEY, nDEFAULT)
run the code and see if that sets it back to 0, if so change it back like it
was and save the file
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Allan" wrote in message
...
Hi Paul
The trouble is I do not know where it is being saved.
This is the macro can you tell me where I find the place to reset the
number;
With .Range("I6")
If IsEmpty(.Value) Then
nNumber = GetSetting(sAPPLICATION, sSECTION, sKEY,
nDEFAULT)
.NumberFormat = "@"
.Value = Format(nNumber, "0000")
SaveSetting sAPPLICATION, sSECTION, sKEY, nNumber + 1&
Cheers. Allan
"Paul B" wrote:

Allan, where every you are storing the number in the macro just change it
back to to 0 there

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Allan" wrote in message
...
I have just setup an 'order' template in excel and inserted a macro
that
increments the number when opened.
I have tested the workbook and I now wish to reset thenumbering system

back
to 0 (zero).
Can anyone advise me how I proceed.
Allan






  #5   Report Post  
nowfal
 
Posts: n/a
Default


Hi,
Its an interesting subject, can you put the enitre code here , so
that others can learn from it. Otherwise the experts, please assist to
have a new one with the same subject as incrementing number in an
invoice of a sheet.
thanks
regards
nowfal


--
nowfal
------------------------------------------------------------------------
nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003
View this thread: http://www.excelforum.com/showthread...hreadid=386396



  #6   Report Post  
Paul B
 
Posts: n/a
Default

nowfal, have a look here for ways to do it,

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"nowfal" wrote in
message ...

Hi,
Its an interesting subject, can you put the enitre code here , so
that others can learn from it. Otherwise the experts, please assist to
have a new one with the same subject as incrementing number in an
invoice of a sheet.
thanks
regards
nowfal


--
nowfal
------------------------------------------------------------------------
nowfal's Profile:
http://www.excelforum.com/member.php...o&userid=10003
View this thread: http://www.excelforum.com/showthread...hreadid=386396



  #7   Report Post  
Allan
 
Posts: n/a
Default

Thanks Paul
That worked perfectly

Cheers
Allan

"Paul B" wrote:

Allen, not sure without seeing all the code but you could try to make
nNumber = 0 and see if that will work, something like this, just put in a 0
and a ' after it to comment out the rest.
nNumber = 0 'GetSetting(sAPPLICATION, sSECTION, sKEY, nDEFAULT)
run the code and see if that sets it back to 0, if so change it back like it
was and save the file
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Allan" wrote in message
...
Hi Paul
The trouble is I do not know where it is being saved.
This is the macro can you tell me where I find the place to reset the
number;
With .Range("I6")
If IsEmpty(.Value) Then
nNumber = GetSetting(sAPPLICATION, sSECTION, sKEY,
nDEFAULT)
.NumberFormat = "@"
.Value = Format(nNumber, "0000")
SaveSetting sAPPLICATION, sSECTION, sKEY, nNumber + 1&
Cheers. Allan
"Paul B" wrote:

Allan, where every you are storing the number in the macro just change it
back to to 0 there

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Allan" wrote in message
...
I have just setup an 'order' template in excel and inserted a macro
that
increments the number when opened.
I have tested the workbook and I now wish to reset thenumbering system
back
to 0 (zero).
Can anyone advise me how I proceed.
Allan






  #8   Report Post  
Allan
 
Posts: n/a
Default

Hi Paul
Where do I 'rate a post'

Allan

"Paul B" wrote:

Allen, not sure without seeing all the code but you could try to make
nNumber = 0 and see if that will work, something like this, just put in a 0
and a ' after it to comment out the rest.
nNumber = 0 'GetSetting(sAPPLICATION, sSECTION, sKEY, nDEFAULT)
run the code and see if that sets it back to 0, if so change it back like it
was and save the file
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Allan" wrote in message
...
Hi Paul
The trouble is I do not know where it is being saved.
This is the macro can you tell me where I find the place to reset the
number;
With .Range("I6")
If IsEmpty(.Value) Then
nNumber = GetSetting(sAPPLICATION, sSECTION, sKEY,
nDEFAULT)
.NumberFormat = "@"
.Value = Format(nNumber, "0000")
SaveSetting sAPPLICATION, sSECTION, sKEY, nNumber + 1&
Cheers. Allan
"Paul B" wrote:

Allan, where every you are storing the number in the macro just change it
back to to 0 there

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Allan" wrote in message
...
I have just setup an 'order' template in excel and inserted a macro
that
increments the number when opened.
I have tested the workbook and I now wish to reset thenumbering system
back
to 0 (zero).
Can anyone advise me how I proceed.
Allan






  #9   Report Post  
Paul B
 
Posts: n/a
Default

Allen, your welcome, as far as rating a post no way that I know of to do it
in a newsgroup like this, other than posting and letting us know that a
solution works for you

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Allan" wrote in message
...
Hi Paul
Where do I 'rate a post'

Allan

"Paul B" wrote:

Allen, not sure without seeing all the code but you could try to make
nNumber = 0 and see if that will work, something like this, just put in

a 0
and a ' after it to comment out the rest.
nNumber = 0 'GetSetting(sAPPLICATION, sSECTION, sKEY, nDEFAULT)
run the code and see if that sets it back to 0, if so change it back

like it
was and save the file
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Allan" wrote in message
...
Hi Paul
The trouble is I do not know where it is being saved.
This is the macro can you tell me where I find the place to reset the
number;
With .Range("I6")
If IsEmpty(.Value) Then
nNumber = GetSetting(sAPPLICATION, sSECTION, sKEY,
nDEFAULT)
.NumberFormat = "@"
.Value = Format(nNumber, "0000")
SaveSetting sAPPLICATION, sSECTION, sKEY, nNumber +

1&
Cheers. Allan
"Paul B" wrote:

Allan, where every you are storing the number in the macro just

change it
back to to 0 there

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from

it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Allan" wrote in message
...
I have just setup an 'order' template in excel and inserted a macro
that
increments the number when opened.
I have tested the workbook and I now wish to reset thenumbering

system
back
to 0 (zero).
Can anyone advise me how I proceed.
Allan








  #10   Report Post  
Allan
 
Posts: n/a
Default

Many Thanks for your help.

Allan


"Paul B" wrote:

Allen, your welcome, as far as rating a post no way that I know of to do it
in a newsgroup like this, other than posting and letting us know that a
solution works for you

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Allan" wrote in message
...
Hi Paul
Where do I 'rate a post'

Allan

"Paul B" wrote:

Allen, not sure without seeing all the code but you could try to make
nNumber = 0 and see if that will work, something like this, just put in

a 0
and a ' after it to comment out the rest.
nNumber = 0 'GetSetting(sAPPLICATION, sSECTION, sKEY, nDEFAULT)
run the code and see if that sets it back to 0, if so change it back

like it
was and save the file
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Allan" wrote in message
...
Hi Paul
The trouble is I do not know where it is being saved.
This is the macro can you tell me where I find the place to reset the
number;
With .Range("I6")
If IsEmpty(.Value) Then
nNumber = GetSetting(sAPPLICATION, sSECTION, sKEY,
nDEFAULT)
.NumberFormat = "@"
.Value = Format(nNumber, "0000")
SaveSetting sAPPLICATION, sSECTION, sKEY, nNumber +

1&
Cheers. Allan
"Paul B" wrote:

Allan, where every you are storing the number in the macro just

change it
back to to 0 there

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from

it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Allan" wrote in message
...
I have just setup an 'order' template in excel and inserted a macro
that
increments the number when opened.
I have tested the workbook and I now wish to reset thenumbering

system
back
to 0 (zero).
Can anyone advise me how I proceed.
Allan









Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In Excel, I want to have all telephone numbers display in the sam. Fluffy from Wisconsin Excel Worksheet Functions 7 March 18th 05 03:05 AM
Excel countif based on size of numbers in one column in Access Kristjan_Thor Excel Worksheet Functions 3 March 17th 05 11:21 PM
Numbers after decimal point excel to word mail merge Andy P Excel Worksheet Functions 1 March 15th 05 12:48 PM
Generating Invoice Numbers Sarah Excel Worksheet Functions 1 January 28th 05 07:51 PM
how do i set up to auto detect duplicated numbers in an excel fiel Peabody Excel Discussion (Misc queries) 1 December 15th 04 09:01 AM


All times are GMT +1. The time now is 02:53 PM.

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

About Us

"It's about Microsoft Excel"