+ Reply to Thread
Results 1 to 1 of 1

Saving active worksheet with new file name and then generate a new invoice number

  1. #1
    Registered User
    Join Date
    04-11-2020
    Location
    Morehead Ky
    MS-Off Ver
    2016
    Posts
    1

    Question Saving active worksheet with new file name and then generate a new invoice number

    I have a invoice work book, my end goal is to save the active invoice sheet with a new file name on my one drive, then clear certain cells within the sheet, then generate the next sheet invoice number sequence. In need of the correct vba to do so. I have tried different ones but i always get an error message. I wanted to type Cntrl +N to do so, so that i can save time. I am new at excel and got the oringinal work book free online and i like the layout of it.
    Last edited by BBs Engravings; 04-11-2020 at 10:09 AM.

+ 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. Replies: 1
    Last Post: 07-07-2014, 09:19 AM
  2. [SOLVED] automatic generate invoice number + 1
    By aimjhun in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2014, 03:15 AM
  3. Saving Invoice where next time I open file the Invoice Number increases by 1
    By domgee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-22-2013, 03:03 PM
  4. Invoice and Its Saving File - Invoice draft
    By kuzna26 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2013, 12:13 AM
  5. Invoice Number and Saving with Invoice Number (auto)
    By Markville in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-03-2007, 06:28 AM
  6. [SOLVED] How do I generate a new invoice number when creating new invoice?
    By KiddieWonderland in forum Excel General
    Replies: 1
    Last Post: 03-14-2006, 11:20 PM
  7. automaticaly generate invoice number?
    By ajkiwi88 in forum Excel General
    Replies: 0
    Last Post: 02-15-2005, 10:21 AM

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