Filter, then copy

[blurtoad]

Hi.

I have the following data in columns A, B and C of Worksheet1

Student_Name Best_Subject Age
AAA English 13
BBB Math 14
CCC English 13
DDD English 14
... ... ... ... ...
ZZZ Science 15

I have created a drop down list in Worksheet2 of "Best_Subj" and "Age".

Please help with the VBA codes which would automatically select the rows (in Sheet1) which satisfy the filtering criteria I have selected and paste these rows into Sheet2, starting from cell("A8").

For example, if I were to select "English" in "Best_Subj" and "13" in "Age" in Worksheet2, the VBA code will automatically filter those rows in Worksheet1 satisfying the selected criteria and copy these rows to Worksheet2, starting from "A8".

Thank you very much

[VBA Noob]

This link may get you started

http://www.rondebruin.nl/copy5.htm#1)


VBA Noob