im trying create an invoice but i need it to pull data from a sheet base on a date range (start date and end date) then fill items from cols. D, F (but instead of "yes" that is displayed putting "Night Out" in the description area of the invoice) also need col J (J is total Hours which gets put in to hours col on invoice) and P and also from another sheet called Expences i need any expences that has been spent put in to the invoice.


let me know if you need any further information. im also looking to add a further feature of the invoices being saved as pdf into another folder out side of worksheet. also giving the option of emailing as well.

here is a copy of my file. not cols in orange

https://www.dropbox.com/s/u2rku0u719...ject.xlsm?dl=0