Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Consequtive numbering spreadsheets

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can you consequtivly number excel spreadsheets? I have a basic form I made and I'm using it as an invoice. After I fill in the form I save it under a new name. The next time I bring up this blank form I would like the next form to come us as form number 2 and so on and so on.

    Thanks Lisa

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes you can.

    But do you mean, is there some way to do this automatically?

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    YES, I WOULD LIKE TO DO THIS AUTOMATICALLY IF I CAN.

    LISA

  4. #4
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You'll need to use VBA and probably sacrifice one obscure cell in your workbook. Still interested?

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes I'm interested, if it is not too difficult. It is something I could really use in my business.

    Thanks Lisa

  6. #6
    New Member
    Join Date
    Apr 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes I'm interested, if it is not too difficult. It is something I could really use in my business.

    Thanks Lisa

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Lisa

    Do you save your sheets as a seperate workbook?
    or
    As an added sheet to the current workbook?

    Tom

  8. #8
    New Member
    Join Date
    Apr 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Tom,

    I save my sheets as a new workbook

    Thanks Lisa

  9. #9
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I can either try and explain
    how to accomplish what you need,
    or you can Email me the sheet,
    I'll add the code in, and mail
    it back. Then you can go through
    the code yourself if you'd like.
    Not sure if you are wanting to learn
    how to do this or just get it done?
    Personally, I would add a button which
    would automatically save the sheet
    with the new name(number) and clear
    the current form for the next invoice.

    Tom

  10. #10
    New Member
    Join Date
    Apr 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Tom,

    Yes, I would really like to get this done.
    I would like to learn how to do it, but it might be over my head. I don't know. I can't email you the sheet until tomorrow because it is on my computer at work.

    Thanks Lisa

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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