Filter and Display Data based on Status

[vs_suresh]

Hello Team,

I have a requirement to display the data based on the filter option selected. I am able to select either 'Open', 'Closed', 'All'. Based on the selection the formula should read the data from 'Data' Sheet and should display the records in the 'Expected' sheet. The records in the Data Sheet will be added on daily basis.

Thanks & Regards,

 

[Brunts]

Presumably you don't trust the users to screw up the "Data" sheet. After you have added to the "Data" sheet each day, what is wrong with just copying all of the data to your "Expected" sheet and the users can just apply a filter for themselves?