VBA code Help very challenging, convert order to PDF and email from multiple sheets

Status
Not open for further replies.

englandmark

Board Regular
Joined
Apr 9, 2015
Messages
62
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

<tbody>
</tbody>



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 soandso@gmail.com
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Status
Not open for further replies.

Forum statistics

Threads
1,213,543
Messages
6,114,240
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top