Hi,
I have the code Dim ws As WorksheetFor Each ws In Workbooks("iteration_status.xlsm").Worksheets
If ws.Name <> "dd" And ws.Name <> "Summary" Then
Call CCIT6
End If
Next
End Sub
where CCIT6 is Range("B7").End(xlToRight).AutoFilter Field:=4, Criteria1:="IT6"Range(Range(Range("B8")...