Filter data from a Master sheet based on multiple criteria by VBA code

Hi All,

I need a vba code for this below problem, i have attached a sample file.

I have a master sheet with data, In the second sheet i have criteria selection, based on criteria, data should be filtered according to the field selected from the master sheet.

The format and the grand total should get adjusted based on the data filtered.
The S.No should be count based on the data filtered.

Any help much appriciated.

Many Thanks
Jude

Hi Oeldere,

Thanks for the reply, I have a formula solution, but the challenge is grand total row should be adjusted according to the data rows, thats the reason i need an vba solution.

Thanks
Jude