VBA code to generate invoice from multiple sheets

  • This seems to be very challenging for me, but i will thank you in advance excel Guru's.
    I have several sheets used for ordering from different divisions and also one for outside sales.
    I would like to generate an invoice from any of the worksheets and send a PDF invoice to my coordinator for sending to the customer.
    Thanks again for any help in advance guys and gals.


    Goal
    To create invoice from several order sheets and email when cell specifies yes to specific employee (Yes is selected Y in last column named Invoice)


    Order sheets (Sheets named RH Commercial, RH Service, RH Residential, Aug Commercial, Aug Service, Outside Sales)

    ABCDEFGHIJKLMNOPQRSTUVWXY
    Invoice #DeliveryCustomers NameAddressCityStatePhone numberDate OrderedDate fabricatedJob numberJob nameDescriptionGaugeQuantity L/fGirthSheetsSheet costMaterial costFab costSell priceL/F CostRPI PriceRPI L/F or EachRPI DiscountInvoice




    Invoice (Sheet name invoice)
    Invoice Number: D6 copy from cell A
    Delivery: D29 copy from cell B
    Customers name: B8 copy from cell C
    Job Name: B9 copy from cell K
    Job Number: D9 copy from cell J
    Billing Address: B10 copy from cell D
    City: B11 copy from cell E
    State: B12 copy from cell F
    ZIP: B13 auto generate from address
    Quantity: A16 copy from cell N
    Description: B16 copy from cell L
    Unit Price: C16 copy from cell W, Outside Sales sheet copy U
    Total: D16 copy from cell V, Outside Sales sheet copy T


    If same customer same address same date fabricated and yes selected add below A16, B16, C16, D16 and below on same invoice
    (Multiple products same order)


    Invoice range A1:D33
    Create PDF attachment to email and send to "[email protected]"[/email]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!