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
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
