+ Reply to Thread
Results 1 to 3 of 3

New Invoice Generating

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    2

    Post New Invoice Generating

    Hi

    Can anyone help Please.

    I have created a atandard invoice.

    1) What i woul like to know is, is there away to place a button on the invoice so that when you press it the current invoice automatically saves to a file by invoice number and then refreshes the invoice ready for the next.

    2) Also, on the invoice i have created VLOOKUP in all of the cells on the product part of the invoice so i.e. when you type in a product code it show the description and prices etc...

    Is it possible to do part 1) and also keep part 2) so it doesnt clear part 2)??

    Any pacro codes you can provide would be appreciated.



    I have managed to create the date and invoice increase using macros so this is not a problem.

  2. #2
    Forum Contributor
    Join Date
    07-24-2009
    Location
    Valrico, FL USA
    MS-Off Ver
    Excel 2016
    Posts
    358

    Re: New Invoice Generating

    Try downloading Invoice Master from the site below and see if it helps

    Please Login or Register  to view this content.

  3. #3
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: New Invoice Generating

    Hello ady armstrong,

    I have done something for someone else a while back, which is very similar to what you are looking for.

    Maybe the attached WorkBook is what you are after.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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