Dear All
How can i filtering the data by copied value?
Exampel:
Sub Cuts_Det()
'
' Cuts_Det Macro
'
' Keyboard Shortcut: Ctrl+q
'
Selection.Copy
Sheets("Cust. Details").Select
ActiveWindow.LargeScroll ToRight:=-1
ActiveSheet.Range("$A$5:$T$10000").AutoFilter Field:=3, Criteria1:="=211", _
Operator:=xlAnd
End Sub
i need to replace "211" by any copied value later.
Many thanks in advance
Bookmarks