Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 1st 05, 06:17 PM posted to microsoft.public.excel.misc
tiredstudent
 
Posts: n/a
Default set increment increase in invoice number it

I am trying to get my invoice to increase in numbers incrementally but I have
not been able to find the method used. Any suggestions?

  #2   Report Post  
Old December 1st 05, 06:21 PM posted to microsoft.public.excel.misc
Paul B
 
Posts: n/a
Default set increment increase in invoice number it

tiredstudent,

A simple way would be to use something like this, you could assign it to a
button, an open or before print event.

Sheets("Sheet1").Range("A1").Value = _

Sheets("Sheet1").Range("A1").Value + 1



For other ways to do this or if this is going to be used in a temple have a
look here

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


"tiredstudent" wrote in message
...
I am trying to get my invoice to increase in numbers incrementally but I
have
not been able to find the method used. Any suggestions?





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
number cell increment +1 when dragging down box Johnny Cake Excel Worksheet Functions 4 August 18th 05 07:29 PM
increment invoice numbers in excel Allan Excel Discussion (Misc queries) 9 July 13th 05 01:44 PM
How do I automatically increment worksheet number when pasting a . Mr Keldor Excel Worksheet Functions 1 April 21st 05 06:06 PM
Automatically number invoice Jaladino Excel Worksheet Functions 0 February 22nd 05 03:12 PM
How do I increment a date by a certain number of weeks? LatestCraze Excel Worksheet Functions 2 December 9th 04 09:05 PM


All times are GMT +1. The time now is 05:50 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017