Template for Tax Calculator for 2014 form India... [ATTACH=CONFIG]59912[/ATTACH] download and use it for free
I Have a data sheet (Summary - All Teams) which will finally be a hidden sheet, and I want to filter the output of this sheet in another sheet (Sector_Summary) by selecting the options in the dropdown list box at N1 cell in Sector_Summary sheet (on selecting a option in the dropdown list a result is reflected in P5 cell). Finally what is required is that on selecting a option (eg. Banks) it's filtered result will be shown in the Sector_Summary sheet (C5 cell) and when another option is selected (eg. Autos) in dropdown list previoes result is erased and new output is shown.