Vba to advance filter data on multiple conditions to many sheets with naming convention

Hi,

I am a basic user of excel but heard about vba from peers to accomplish task quickly and unfortunately I don't have much knowledge about vba.

My question.
===========

I have raw data where I have Names of people and their grades for their subjects and I am in need of a vba code which will extract data from raw sheet based on their names and grade. (two criteria)

I have attached a sample sheet for better understanding.

Except rawdata sheets the other sheets are output sheets which are named based on names and grades, I hope that naming convention can also be addressed by vba

Note: The list of raw data can grow so I am wondering if we can make it dynamic.

Please help!!!

Thanks!


Hope someone will help.

Hi Jaslake

Yes, all the Output Worksheets should get cleared and then recreated with the new data.

Thanks!