Automaticlly update another workbook daily

[Lbunm]

I have a workbook that I update often entering orders for each date, and it have all our orders on it, then I need to create a separed one to load the only daily orders, that one i will upload on our invoicing system.
I was hopping someone can assiste me with that. I would like to have this second workbook updated automaticaly. It only needs to bring invoice date, and amout based on todays date =date(),
Thanks

 

[MrTeeny]

What you're asking doesn't sound too hard it just needs more info for anyone to pop up some worthwhile code, when you say automatically do you when you close the sheet with all orders, when a new entry is added etc Is this new sheet to be named by date or the same sheet with old data deleted each time it's updated?

 

[Lbunm]

Yes, i need the same sheet with old data to be deleted and have the new data for the current date entered.
The spreadsheet where I enter all data is named "2017 Funds Jornal". And the new spreadsheet: "daily inv update".
from "2017 founds jornal" the code will pull everything that match with today's date and bring Column "F" (order number", will will be the invoice #, and column "c" card orders" this will be the "inv amount" on the spreadsheet called daily inv update.