Copy rows from sheet based on selected values and paste into new sheet

Hello,
I have attached a sample workbook. I want to copy the rows from Sheet 2 that have the same 'Tally' values as Sheet 1  and paste them into Sheet 3.  Can this be done with a macro or formula? Annotation is always appreciated.

Thanks you,
JE
JE-Select-EE.xls
justearthAsked:
Who is Participating?
 
nutschConnect With a Mentor Commented:
You can do that with an advance filter, and you could put it in a macro. See the attached screencast.

name your data (you need that for filter between tabs)
goto sheet 3
advanced filter
fill in parameters

you're done

Thomas
nutsch-424564.flv
0
 
justearthAuthor Commented:
Thanks.
0
 
nutschCommented:
Glad to help. Thanks for the grade.

Thomas
0
All Courses

From novice to tech pro — start learning today.