So I keep getting an error 1004 on this line when I want to filter a drop-down set from cell C4 - any ideas why?
Sub Update()
ActiveWorkbook.RefreshAll
Columns("L:L").EntireColumn.AutoFit
Selection.EntireColumn.Hidden = False
ActiveSheet.Range("$L$4").AutoFilter Field:=1...