Results 1 to 21 of 21

Auto invoice generate number with Save as PDF Macro with

Threaded View

Tai1001 Auto invoice generate number... 04-11-2015, 07:19 AM
Sean Thomas Re: Auto invoice generate... 04-11-2015, 07:55 AM
Tai1001 Re: Auto invoice generate... 04-11-2015, 08:16 AM
Blokeman Re: Auto invoice generate... 04-11-2015, 08:25 AM
Tai1001 Re: Auto invoice generate... 04-11-2015, 08:43 AM
Sean Thomas Re: Auto invoice generate... 04-11-2015, 08:51 AM
Tai1001 Re: Auto invoice generate... 04-11-2015, 09:05 AM
Sean Thomas Re: Auto invoice generate... 04-11-2015, 09:23 AM
Blokeman Re: Auto invoice generate... 04-11-2015, 09:31 AM
Tai1001 Re: Auto invoice generate... 04-11-2015, 09:53 AM
Sean Thomas Re: Auto invoice generate... 04-11-2015, 11:26 AM
Tai1001 Re: Auto invoice generate... 04-11-2015, 11:59 AM
Sean Thomas Re: Auto invoice generate... 04-11-2015, 01:25 PM
Tai1001 Re: Auto invoice generate... 04-11-2015, 01:32 PM
Sean Thomas Re: Auto invoice generate... 04-11-2015, 01:38 PM
Sean Thomas Re: Auto invoice generate... 04-11-2015, 01:37 PM
Tai1001 Re: Auto invoice generate... 04-11-2015, 01:38 PM
Tai1001 Re: Auto invoice generate... 04-11-2015, 02:55 PM
Sean Thomas Re: Auto invoice generate... 04-11-2015, 05:21 PM
Tai1001 Re: Auto invoice generate... 04-12-2015, 06:51 AM
Tai1001 Re: Auto invoice generate... 04-12-2015, 10:23 AM
  1. #1
    Registered User
    Join Date
    03-17-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    51

    Question Auto invoice generate number with Save as PDF Macro with

    Hello Guys,

    In my school project I have to create an invoice on excel which can generate an invoice number (+1 to previous one) when saved, the save as function should be a PDF format. so we can email it.
    Once we have created the PDF we need to go to main screen and clear the fields. we should be able to repeat the above so the invoice numbers keep on rolling.

    So if we break it down we need 3 macros:

    1) Auto generate invoice number (Macro called Finalise)
    2) Save as PDF Macro, file name should be the new generated auto invoice number. (Macro called Generate)
    3) Save the current EXCEL file (so the invoice number is maintained) and return to the homepage and clear the cells with data so we can start a new invoice. (Macro called Return)

    Homepage tab name: Basic Info
    Homepage cells to clear: J4, Q4, J6, Q6, J8, Q8, J10, Q10, J12, Q12, J14, Q14

    Invoice AutoNumber field where invoice number is required: DTA!G19 (sheet tab: DTA, Cell number: G19)
    Invoice Number format: "QLHR-J18-01" (the value in BasicInfo!J18)

    Please let me know if the above is possible,

    Thanks in advance guys

    Tai
    Last edited by Tai1001; 04-11-2015 at 07:25 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto Invoice Number Generate in Excel
    By iqubalemco in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-09-2014, 02:44 AM
  2. Macro to automatically generate invoice number
    By Tahya in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2014, 04:39 PM
  3. I need a macro that will create a new sheet, generate invoice number
    By Daotor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2013, 09:20 AM
  4. Auto generate invoice number of each supplier
    By shafiqe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-27-2013, 12:48 PM
  5. Auto Generate Sequential Invoice Number
    By jneldon in forum Excel General
    Replies: 1
    Last Post: 03-09-2009, 01:17 PM

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