copy and paste - vba

[itaye]

heyy
please help

i have a table with 4 columns. the first column is the name and the other, info than belongs to the firs column .
i have try to make a macro for this but its not possible becouse the name dosnt appear in the same row. exp: Itay (my name) appear sometimes in row 3/6/7/12, but in a diffrent day its appear in row 1/2/3/4

what i need:
1.search the name
2. copy the name and the next columns
3. past in a differnt sheet

i need it with a macro (vba)

thanks

 

[kaemerso]

Do this within the macro-recorder first.
Then paste that code here so that one of the excel experts may have a starting point to help you.

 

[itaye]

hey
thanks!


Sub ITAY()
'
' ITAY Macro
'


'
ActiveSheet.Range("$A$1:$A$27").AutoFilter Field:=1, Criteria1:="=*ITAY*", _
Operator:=xlAnd
Range("A2:D18").Select
Selection.Copy
Sheets("ITAY").Select
ActiveWindow.SmallScroll Down:=-3
Range("A1").Select
ActiveSheet.PASTE
Sheets("allcm").Select
Range("D33").Select
Application.CutCopyMode = False
End Sub