Macro to bring all data from a row if today's date

[Lbunm]

I need a big help on this
I have a spreadsheet called "2017 Funds Journal" and that is where I enter all order for the whole year, another department needs the invoice number and order amount from this spreadsheet so they can upload for invoice processing. Instead of having to update this file for them every day I would like a macro to update that for me.
My workbook:
Transaction date / Payment account / Card Orders / Return / Balance / Order Number

If the transaction date match with today's date and considering that each one of these fields is in a # column, I would like my Macro to bring in a new spreadsheet called "Daily Inv Update" the "Card Orders" Column C and Order Number Column F.
So it will look:
Date: Today () /Order Number / Card Orders /
Date: Today () /Order Number / Card Orders /
Date: Today () /Order Number / Card Orders /

I appreciate any help with this as I am still learning about all of this
Thanks

 

[MARK858]

I would like my Macro to bring in a new spreadsheet called "Daily Inv Update"

If you mean "Daily Inv Update" is just a worksheet name then try the code below...

Sub Macro4()
    With Sheets("2017 Funds Journal").Range("A1:F" & Sheets("2017 Funds Journal").Range("A" & Rows.Count).End(xlUp).Row)
        .AutoFilter Field:=1, Criteria1:=xlFilterToday, Operator:=xlFilterDynamic
        Intersect(.Offset(1).Resize(.Rows.Count - 1).SpecialCells(xlCellTypeVisible), Sheets("2017 Funds Journal").Range("A:A,C:C,F:F")).Copy Sheets("Daily Inv Update").Range("A1")
        .AutoFilter
    End With
    Sheets("Daily Inv Update").Columns("C:C").Cut
    Sheets("Daily Inv Update").Range("B1").Insert Shift:=xlToRight
End Sub

If not then give both workbook and worksheet names for both files.