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