[Q] Grouped data sorting & filtering

[m.hamadeh]

Hello Excel experts, I have a groped data as per attached excel link, I need a way to set a filter cell to execute customizable combination filters & sorting. Any ideas?

http://db.tt/CgjVQ4p

Regards, m.hamadeh

 

[m.hamadeh]

Up up

 

[m.hamadeh]

Maybe my question was not clear enough; I need a formula or VBA to filter based on parameters and as a result the entire range where the other related data to be included in the filter. That meaning each box (data group) to be treated as single object.