Help auto filtering dynamic data table

[russelldt]

I have been using the following (successfully) to auto filter an excel table (containing invoices) that copied data from a source file.



Private Sub Workbook_Open()
With Sheets("Invoice log")
.AutoFilterMode = False
.Range("C3", .Range("C" & Rows.Count).End(xlUp)).AutoFilter Field:=1, Criteria1:=Sheets("Cashflow input").Range("E4").Value
End With
End Sub



Having changed to Excel 365 and One Drive, I now want to use the Dynamic Data ability to keep the table containing invoiced up to date, and then auto filtering them once again.

I have created the link but the above filter does not work. I have checked the cell references, and they are all correct. What happens is that Column A is used as the filter selection, and not Column C.

Any suggestions here? Thanks

 

[russelldt]

Solved this, please dont bother responding,

Cheers