+ Reply to Thread
Results 1 to 2 of 2

Macro (button) to Push all the information to another shee, and "Save As" the file.

  1. #1
    Registered User
    Join Date
    01-20-2012
    Location
    HK
    MS-Off Ver
    Excel 2010
    Posts
    14

    Macro (button) to Push all the information to another shee, and "Save As" the file.

    Hello,

    I am trying to build an invoice system for my office where by they will

    1) Open a template invoice file
    2) Fill out the details in 7 specific cells. Invoice No (b1), No. of Cartons(c5), Date (g1), Document no (c3), Shipper Name(a10), Order No(b2), and Order Value(g12).
    3) When they press a certain button on the sheet, I want all of the above information flow into a separate worksheet with column headings of the same 7 items listed above.
    4) I also want a save as window to pop-up so that they can save this invoice under a different name, as to not affect the template invoice file.

    Any advice?

    I know almost 0 about VBA, so code would be very much appreciated.

    Thanks

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Macro (button) to Push all the information to another shee, and "Save As" the fil

    Try this code. I have done a small modification. The code will ask you to open the invoice template, then provide you 7 input boxes so you can input the values. These values will be entered into the invoice template as well as the summary file as you required. Then it will prompt you to saveas the invoice file.
    Please Login or Register  to view this content.
    You can have this code in a separate macro file or if you want you can include it in your summary file (i have to just make a few changes to the code).
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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