Invoice Number + 1, Auto Appear

[Kohinoor]

Cell D15 is my Invoice Number Field.

I have entered my invoice number starting from 001. I am doing this manually every time after referring the previous Invoice Number in the next sheet( i.e., Sheet 2)

I have a macro "SAVE" in Invoice Page, which copies the S.No, Name , Qty and Amount from the Invoice page to the next Sheet i.e., ( Sheet 2). This copies row by row in the next page after every Invoice is done.
After Copying the above said datas, I have another Macro "NEW" which deletes the S.No Field, Name, Qty and Amount Field for keeping the Invoice ready for the next Feed.

Is it possible to auto increase the invoice number + 1 in the Invoice Filed, based on the copied Invoice number in the Next Sheet ( Sheet 2 ). Provided, hitting the "New" button for the next feed should not affect the S.No Field.

Kindly Help.

Jane

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[mudraker]

As long as you have the invoice last invoice number stored then you can use a macro to look up the invoice number & add 1 to it & place it as required


Please explain why With your DeleteStuff macro you are using a loop & clearing the contents if they are numeric or not numeric

Please Login or Register  to view this content.

why not just use

Please Login or Register  to view this content.

Why in your saveit macro you are using a loop & select case to populate a range of cells


Surly the following code does the same as your loop

Please Login or Register  to view this content.

[JBeaucaire]

Cross post:
http://www.mrexcel.com/forum/showthread.php?t=376232

[mudraker]

Please take a couple of minutes and read ALL the Forum Rules
[

I]Your post does not comply with Rule 8 of our Forum [/I]RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!


As JBeaucaire has taken the trouble to provide the link to your Cross Posted thread this thread will not be closed as stated in the rules

PS thanks JBeaucaire

[excellentexcel]

i am now off to work and havent got the time right now but i have a purchase order set up for exactly the same thing.
broro did it for me and is really good. you may be able to use it. i will upload it tonight as soon as i get home from work