Invoice Description items based on start and end date

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

Can anyone Help please

Originally Posted by Glenn Kennedy

Sorry to be a bit thick - but what numberr/field on the proposed invoice is being used to link back to the data on the other sheets?

the date on the left of the invoice next to description, see what i propose to do is once the invoice is filled out i intend to add a save button to save the invoice as pdf and then save it to a folder

Originally Posted by Glenn Kennedy

In your example, none of the "Bill to" agencies in the drop down on invoice appear on the Agency Daily Input sheet (where you want the data to be drawn from). Is that correct?

B18 will have a list box filled on the infomation (in this case date) and information will be as described on the invoice page

sure so long as there are some explanations a long the way if needed

i made some modifications to my worksheet.

Can you take a look please

https://www.dropbox.com/s/ghhxvp5cnm...oice.xlsm?dl=0

im hoping you can see what it is that im trying to get at from this