Can anyone advise me on the code I would need to add to the following line of code in order for it to use cell C9 from another workbook as the basis of the autofilter?
Currently the line of code works when using C9 on the "Responsible Work to List" sheet within the current workbook.Selection.AutoFilter Field:=13, Criteria1:="=*" & Sheets("Responsible Work to List").Range("C9") & "*"
For purpose of example; the other workbook is named "Concern Tracker" and the sheet I want to to refer to cell C9 is on "Sheet1".
Having a stab myself, would I need to add something along the lines of:
???Selection.AutoFilter Field:=13, Criteria1:="=*"workbooks("Concern Tracker") & Sheets("Responsible Work to List").Range("C9") & "*"
Thanks in advance for any help!
Bookmarks