Hi everyone, I'm putting together a larger macro but need help with the first step...hoping you can provide some guidance
Here is some code, instead of Criteria being the specific Name ie Criteria1:= "Rodgers, Aaron", I'd like it to reference a Names tab. So it would select the first name on Names tab, copy the selection, and paste it into another tab. Thank you very much
Code
Sub test()
'
' test Macro
'
'
Sheets("Detail").AutoFilter Field:=2, Criteria1:= _
Sheets("Names").Select
Range("A2").Select
Cells.Select
Selection.Copy
Sheets("PASTE").Select
Cells.Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
Display More