Hi
I hope somebody can help me. I need to repeat an action many time. I put a filter with initial from a list and copy the data in a sheet and save it.
ActiveSheet.Range(A1:T788).Autofilter Field:=8, Criterial:"TFB"
Range(A1:U788).select
Selection.copy
workbooks.add
activesheet.paste
How can choose criterial from a list
TFB
FXH
CG
PAM
KLP
etc
Thanks in advance
Patice
I hope somebody can help me. I need to repeat an action many time. I put a filter with initial from a list and copy the data in a sheet and save it.
ActiveSheet.Range(A1:T788).Autofilter Field:=8, Criterial:"TFB"
Range(A1:U788).select
Selection.copy
workbooks.add
activesheet.paste
How can choose criterial from a list
TFB
FXH
CG
PAM
KLP
etc
Thanks in advance
Patice