I have this filter and CopyToRange but is does not include any hyperlink. Is there an easy way modify to include any hyperlink.
Sub Review()
Application.ScreenUpdating = False
Set area = Sheet2.Range("a2:l100000") '
area.AdvancedFilter Action:=xlFilterCopy _
, CriteriaRange:=Sheet1.Range("b3:k4"), CopyToRange:=Sheet1.Range("c8:n8"), _
Unique:=False
Application.ScreenUpdating = True
Sheet1.Select
End Sub
Sub Review()
Application.ScreenUpdating = False
Set area = Sheet2.Range("a2:l100000") '
area.AdvancedFilter Action:=xlFilterCopy _
, CriteriaRange:=Sheet1.Range("b3:k4"), CopyToRange:=Sheet1.Range("c8:n8"), _
Unique:=False
Application.ScreenUpdating = True
Sheet1.Select
End Sub