Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Invoice in Excel

This is a discussion on Invoice in Excel within the Excel Questions forums, part of the Question Forums category; Here is what i am trying to make an Invoice like this ******** ******************** ************************************************************************> Microsoft Excel - Order.xls ___Running: ...

  1. #1
    Spammer
    Join Date
    Jan 2004
    Location
    in the process of locating.
    Posts
    372

    Default Invoice in Excel

    Here is what i am trying to make an Invoice like this

    ******** ******************** ************************************************************************>
    Microsoft Excel - Order.xls___Running: 11.0 : OS = Windows XP
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    1
    ***********
    2
    ***********
    3
    *PRODQLTYQTYPRICEDISCPRICE*AFTER*DISCNET*AMOUNT*Vol*Per*PieceTotal*Volume
    4
    *22x22x4FS10035750178.517850************1,936*193600
    5
    *22x18x3D1501775088.513275************1,188*178200
    6
    *78x60x5FSP2523000230057500**********23,400*585000
    7
    *GaoBQ2512501253125************2,000*50000
    8
    *PillowBQ100700707000************1,700*170000
    9
    ***********
    10
    ***********
    11
    ******Total*Amount************98,750**********1,176,800*
    12
    ***********
    13
    ******Total*Volume*******1,176,800****
    14
    ***********
    Sheet1*

    [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.


    i have a price list in another sheet . I want that i write Product ,Quality and Quantity the Rest of things are picked up from the Price List in another sheet of the same workbook. The Discount is also mentioned along with the Name of Quality Ill show u in the next Post

  2. #2
    Spammer
    Join Date
    Jan 2004
    Location
    in the process of locating.
    Posts
    372

    Default Re: Invoice in Excel

    The invoice is on sheet two of the same file and looks something like this as shown here can any one help me out how to make That Invoice working The maximum Entries in That Invoice are 50 in Product Column



    ******** ******************** ************************************************************************>
    Microsoft Excel - Order.xls___Running: 11.0 : OS = Windows XP
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    A
    B
    C
    D
    E
    F
    G
    2
    *******
    3
    *PRODFS=50DEC=50EAG=57BQ=0*
    4
    *22x22x4357288245**
    5
    *22x22x3269217183**
    6
    *22x22x3180144122**
    7
    *22x18x3227177151**
    8
    *18x18x3185144122**
    9
    *Gao***125*
    10
    *Pillow***70*
    11
    *******
    Sheet2*

    [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454

    Default Re: Invoice in Excel

    Hi TheBuGZ:

    The layout in sheet2 is not that of an Invoice -- rather the layout in Sheet1 is more like an invoice.

    Please define the various terms what they mean and what these have to do with pricing the item, and please make your question very specific. You may know exactly what you are trying to accomplish but the viewers can only go by what you clearly describe on the board.
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  4. #4
    Spammer
    Join Date
    Jan 2004
    Location
    in the process of locating.
    Posts
    372

    Default Re: Invoice in Excel

    well sheet 2 is actually a price list i want Invoice to get values from that price list

    I just had to enter size

    Product Quality Quantity
    22x22x4 FS 50



    The Rest thing Comes up by itself the discount and all the things further come up from the source i.e Price List


    Plz Help me!!!!

  5. #5
    Board Regular
    Join Date
    Jan 2003
    Location
    CA, Bay Area
    Posts
    2,062

    Default Re: Invoice in Excel

    Read the help file on the VLOOKUP function. Also read the SUMIF function.

  6. #6
    Spammer
    Join Date
    Jan 2004
    Location
    in the process of locating.
    Posts
    372

    Default Re: Invoice in Excel

    I surely am not that SMARTER or CAPABLE than what u have just thoughtof me.
    If i could have done it on my own why would i be here giving u ppl trouble.

  7. #7
    Board Regular
    Join Date
    Jan 2003
    Location
    CA, Bay Area
    Posts
    2,062

    Default Re: Invoice in Excel

    I certainly apologize if my brief note came across as abrupt or rude. Nothing like that was intended.

    Nonetheless, the VLOOKUP function is not that hard to decipher. Based on a lookup value, in your case a cell containing a code number, it can return another cell's value, in your case a unit price. I have used it in applications such as:

    I get a online report from my phone company of my monthly transactions. I download it, sort it by called-number and then use COUNTIF, SUMIF and VLOOKUP functions to give me counts of calls to each number, total costs to each number and other important info.

    If after comtemplating those functions you still need more tutoring, please feel free to indicate that.

  8. #8
    Spammer
    Join Date
    Jan 2004
    Location
    in the process of locating.
    Posts
    372

    Default Re: Invoice in Excel

    well nothing about U Bro i was telling about myself

  9. #9
    Spammer
    Join Date
    Jan 2004
    Location
    in the process of locating.
    Posts
    372

    Default Re: Invoice in Excel

    Please Bail me out I am stuck plz! plz!! plz!!!

  10. #10
    Legend just_jon's Avatar
    Join Date
    Sep 2002
    Location
    Alabama/State of Disarray
    Posts
    10,473

    Default Re: Invoice in Excel

    ******** ******************** ************************************************************************>
    Microsoft Excel - Book1___Running: xl2000 : OS = Windows Windows 2000
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    B
    C
    D
    E
    F
    G
    H
    I
    J
    2
    QualitySize1st2nd3rd4th5thMix*
    3
    Discount50525762670*
    4
    Product22x22x4357288245176135Gao125
    5
    22x22x3269217183165120Pillow70
    6
    22x22x2185144122111103Sides60
    7
    22x18x3227177151134118Head80
    8
    18x18x3185144122111101Bottom65
    Sheet2*

    [HtmlMaker 2.40] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.


    ******** ******************** ************************************************************************>
    Microsoft Excel - Book1___Running: xl2000 : OS = Windows Windows 2000
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    B
    C
    D
    E
    F
    G
    H
    I
    J
    3
    ProductQualQtyU/PDisc.Net*U/PTotal*Net*PriceVol*Per*PieceTotal*Volume
    4
    22x22x41st12535750%*178.50*22,312.50*************1,936**********242,000*
    5
    22x22x32nd17521752%*104.16*18,228.00*************1,452**********254,100*
    6
    22x18x33rd7515157%***64.93*4,869.75*************1,188************89,100*
    7
    18x18x35th12510167%***33.33*4,166.25****************972**********121,500*
    8
    22x22x25th7510367%***33.99*2,549.25****************968************72,600*
    9
    GaoMix251250%*125.00*3,125.00*************2,000************50,000*
    10
    PillowMix100700%***70.00*7,000.00*************7,000**********700,000*
    Sheet1*

    [HtmlMaker 2.40] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

    Formulas:
    E4: =IF(ISNUMBER(--LEFT(B4,1)),VLOOKUP(B4,Sheet2!C$4:H$8,MATCH(C4,Sheet2!C$2:H$2,0),0),VLOOKUP(B4,Sheet2!I$4:J$8,2,0))
    F4: =INDEX(Sheet2!D$3:I$3,0,MATCH(C4,Sheet2!D$2:I$2,0))/100
    G4: =E4-E4*F4
    H4: =D4*G4
    I4: =IF(B4="Pillow",D4*G4,EVAL("="&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B4,"Gao",2000),"x","*"),"mm","/25.4")))
    J4: =D4*I4
    just_jon
    Book of the Month: I'm Not Really an MVP, I Just Play One on TV [j. jon, 2004]

Page 1 of 2 12 LastLast

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