https://community.blueprism.com/t5/Product-Forum/Filter-in-excel/m-p/65205#M17845 The Process Examples distributed with the Templates (mandatory training) include 'Process Examples - Templates' that I can recommend you import into Blue Prism and look at for an example of how to filter a collection (using the Filter Collection action). Wed, 17 May 2017 17:06:00 GMT Denis__Dennehy 2017-05-17T17:06:00Z https://community.blueprism.com/t5/Product-Forum/Filter-in-excel/m-p/65201#M17841 Hi, Let me know how to filter excel and copy these values to new sheet. Attached excel for reference. Fri, 12 May 2017 14:30:00 GMT https://community.blueprism.com/t5/Product-Forum/Filter-in-excel/m-p/65201#M17841 jayachandraredd 2017-05-12T14:30:00Z https://community.blueprism.com/t5/Product-Forum/Filter-in-excel/m-p/65202#M17842 Hi You can use BPA Object - MS Excel.xml which is located in the installation folder such as ""C:\Program Files\Blue Prism Limited\Blue Prism Automate\VBO"". Probably the actions of ""Select"" and ""Copy and Paste Worksheet Range"" work for you. Hope it helps. Fri, 12 May 2017 15:20:00 GMT https://community.blueprism.com/t5/Product-Forum/Filter-in-excel/m-p/65202#M17842 tjunicho 2017-05-12T15:20:00Z https://community.blueprism.com/t5/Product-Forum/Filter-in-excel/m-p/65203#M17843 If you are not able to find anything in Excel VBO then get data from first excel into collection. Filter the collection using filter collection action and finally create a new excel/sheet using filtered collection. Fri, 12 May 2017 16:32:00 GMT https://community.blueprism.com/t5/Product-Forum/Filter-in-excel/m-p/65203#M17843 SandeepKumar7 2017-05-12T16:32:00Z https://community.blueprism.com/t5/Product-Forum/Filter-in-excel/m-p/65204#M17844 Filter Collection is not based on the column and I am looking column filter. I tried using ""Utility - Collection manipulation"" BO and ""Collection Contains Value"" action. Provided values for collection, column name, exact value as per excel. But I am not getting any output. Please provide further info. Fri, 12 May 2017 16:57:00 GMT https://community.blueprism.com/t5/Product-Forum/Filter-in-excel/m-p/65204#M17844 jayachandraredd 2017-05-12T16:57:00Z https://community.blueprism.com/t5/Product-Forum/Filter-in-excel/m-p/65205#M17845 The Process Examples distributed with the Templates (mandatory training) include 'Process Examples - Templates' that I can recommend you import into Blue Prism and look at for an example of how to filter a collection (using the Filter Collection action). Wed, 17 May 2017 17:06:00 GMT https://community.blueprism.com/t5/Product-Forum/Filter-in-excel/m-p/65205#M17845 Denis__Dennehy 2017-05-17T17:06:00Z