+ Reply to Thread
Results 1 to 9 of 9

Create Unique Sequence Number in Cell for invoice

  1. #1
    Registered User
    Join Date
    11-13-2015
    Location
    Athens
    MS-Off Ver
    15
    Posts
    5

    Question Create Unique Sequence Number in Cell for invoice

    Hello. I am new in excel and to this forum.
    I have this situation:

    I have an invoice template and in one cell I must fill in a unique number and always must increase by 1 . For example if previous number was 300 next number must be 301 etc....
    For me this cell is K5.
    In more details I want to open the template and automatically K5 cell gets this number from the previous invoice.Also I need to save each invoice automatically and get the name of the file from two different cells with an underscore ( _ ) between in a folder which I will specify. And for the end when I save the file I want to clear a range of cells from the invoice and get ready for the next one.
    Can anyone help me please?

    Thank you
    John

    Keep in mind that I have post this thread to other forums as well and if it is answer I will close the thread.The reason for this was that I am in dead end.
    http://www.ozgrid.com/forum/showthread.php?t=197548
    http://www.mrexcel.com/forum/excel-q...mber-cell.html
    Last edited by ioannisg; 11-13-2015 at 09:32 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,365

    Re: Create Unique Sequence Number in Cell for invoice

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced (next to quick post),
    • Scroll down until you see "Manage Attachments",
    • Click that then select "add files" (top right corner).
    • Click "Select Files" find your file, click "open" click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Click "Done" at bottom right to close the Attachment Manager.
    • Click "Submit Reply"
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    348

    Re: Create Unique Sequence Number in Cell for invoice

    Hi ioannisg,

    Check this;http://www.excelforum.com/excel-prog...locations.html
    Please click the * Add Reputation if this helps
    If solved remember to mark Thread as solved

    "I'm glad to help and this is not meant to sound smart, but either you have super-human vision to see all those controls cleared one by one with the code I posted, or your computer is really slow."

  4. #4
    Registered User
    Join Date
    11-13-2015
    Location
    Athens
    MS-Off Ver
    15
    Posts
    5

    Re: Create Unique Sequence Number in Cell for invoice

    Quote Originally Posted by protonLeah View Post
    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced (next to quick post),
    • Scroll down until you see "Manage Attachments",
    • Click that then select "add files" (top right corner).
    • Click "Select Files" find your file, click "open" click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Click "Done" at bottom right to close the Attachment Manager.
    • Click "Submit Reply"
    Here is the file you asked.Thank you
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-13-2015
    Location
    Athens
    MS-Off Ver
    15
    Posts
    5

    Re: Create Unique Sequence Number in Cell for invoice

    Quote Originally Posted by Blokeman View Post
    Thank you Blokeman. I saw the post and tried the code but I didn't make it.....I am having problems....Can you help me?

  6. #6
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    348

    Re: Create Unique Sequence Number in Cell for invoice

    can you post the code?

  7. #7
    Registered User
    Join Date
    11-13-2015
    Location
    Athens
    MS-Off Ver
    15
    Posts
    5

    Re: Create Unique Sequence Number in Cell for invoice

    Quote Originally Posted by Blokeman View Post
    can you post the code?
    Sure:

    Please Login or Register  to view this content.
    Last edited by ioannisg; 11-14-2015 at 07:49 AM.

  8. #8
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    348

    Re: Create Unique Sequence Number in Cell for invoice

    Try the uploaded file;
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    11-13-2015
    Location
    Athens
    MS-Off Ver
    15
    Posts
    5

    Re: Create Unique Sequence Number in Cell for invoice

    Thank you Blokeman!!! Your code didn't worked for me but this worked:
    Please Login or Register  to view this content.
    This wrote it cytop here http://www.ozgrid.com/forum/showthread.php?t=197548

    The only thing now is that you see some fields with garbbish characters.This is why I use my Mac and VBA does support Greek characters....I can work it in Windows only....
    Is there a solution to this?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. create unique invoice no and check against list
    By alan h m in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 02-10-2015, 04:12 AM
  2. [SOLVED] Creating Unique Number Sequence
    By CCSLBuckles in forum Excel General
    Replies: 3
    Last Post: 10-12-2014, 12:16 AM
  3. Create a number sequence and restart when a cell value equals a criteria
    By manian in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-15-2013, 02:46 AM
  4. Create unique number from 2 cell values?
    By gtudor in forum Excel General
    Replies: 6
    Last Post: 03-09-2012, 06:25 AM
  5. unique number sequence
    By stormrider in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-05-2007, 02:25 PM
  6. [SOLVED] How do I assign a unique ID number to an invoice sheet I created?
    By Matt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2006, 01:15 PM
  7. Macro for a unique sequence number
    By Josh_123456 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2005, 08:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1