Results 1 to 5 of 5

invoice

This is a discussion on invoice within the Excel Questions forums, part of the Question Forums category; Hi guys. I have little problem here hope to find a solution soon I have created an invoice in excel ...

  1. #1
    Board Regular
    Join Date
    Feb 2017
    Posts
    130

    Default invoice

    Hi guys.
    I have little problem here hope to find a solution soon
    I have created an invoice in excel and a account for receiving payments from people. All i want is to auto add invoice value in account for every time i creat a new invoice.
    5 invoices 5 values in accounts. Automatically. I dont want these values to add manually.

    Thanks waiting

  2. #2
    Board Regular FDibbins's Avatar
    Join Date
    Feb 2013
    Location
    Duncansville, PA USA
    Posts
    5,440

    Default Re: invoice

    You will need to provide a LOT more ifo that than.

    what will the invoice value be?
    what cells are involved?
    when will it be applied?
    how would we know when it needs to ne applied?
    etc

    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    Regards

    Ford

  3. #3
    Board Regular
    Join Date
    Jan 2009
    Location
    uk bexhill sussex
    Posts
    1,602

    Default Re: invoice

    Well yes, more info.

    I think i would do it with a button.
    So that when the button is clicked it adds 1 more to a cell value on each press.
    There would be allot to think about regarding the whole project i would think, storing the invoice data to look up later for example.

    But i guess you know your own project.
    personally i would create an invoice template and on button press save all the values from the template into another sheet with columns of data, 1 line per invoice number.
    This way you could retrieve old invoice data with a search.

    but code like this in the button would simply add 1 per press

    range("a1") = range("a1") + 1

    dave
    Some one always knows more than me,thats why I am here.

  4. #4
    Board Regular
    Join Date
    Feb 2017
    Posts
    130

    Default Re: invoice

    Invoice value will depand on the sale. One cell of invoice having total amount and one column of debit from account.
    Whenever the invoice value change it should auto add to the debit column of accounts.

  5. #5
    Board Regular
    Join Date
    Feb 2017
    Posts
    130

    Default Re: invoice

    I have invoice num in Cell A8 in sheet invoice,i mean that every i change invoice num in cell A8 amount in cell F32 will go to column E
    start from E7 in sheet account,how is it possible?
    Last edited by meytithveasna; Mar 20th, 2017 at 11:50 PM.

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
  •  


DMCA.com