https://community.blueprism.com/t5/Product-Forum/Sort-in-Excel-VBO/m-p/49691#M5049 Hi Prateelk.Thank you so much. I tried Utility collection sort, but can't sort. New collection for sorted data remains empty,and message ""can't find Row1"" is shown. Why I can't sort? And is there guide about each action of Utility collection? After sorting,I want to delete some lines (Keep top 3 line and delete the rest).But I don't know the way of delete, so I need help or guide. Best regarads. Tue, 04 Apr 2017 13:25:00 GMT asako_morimoto 2017-04-04T13:25:00Z https://community.blueprism.com/t5/Product-Forum/Sort-in-Excel-VBO/m-p/49689#M5047 In Excel,I want to use data sort function(Refer to Attach Image). How can I do above in Excel VBO? Or is it impossible, then should I do in Application Modellar by Global send key? Tue, 04 Apr 2017 07:21:00 GMT https://community.blueprism.com/t5/Product-Forum/Sort-in-Excel-VBO/m-p/49689#M5047 asako_morimoto 2017-04-04T07:21:00Z https://community.blueprism.com/t5/Product-Forum/Sort-in-Excel-VBO/m-p/49690#M5048 Hey mocha, Copy the data to the collection and sort via Utility collection sort action. Tue, 04 Apr 2017 11:36:00 GMT https://community.blueprism.com/t5/Product-Forum/Sort-in-Excel-VBO/m-p/49690#M5048 PrateekMehan 2017-04-04T11:36:00Z https://community.blueprism.com/t5/Product-Forum/Sort-in-Excel-VBO/m-p/49691#M5049 Hi Prateelk.Thank you so much. I tried Utility collection sort, but can't sort. New collection for sorted data remains empty,and message ""can't find Row1"" is shown. Why I can't sort? And is there guide about each action of Utility collection? After sorting,I want to delete some lines (Keep top 3 line and delete the rest).But I don't know the way of delete, so I need help or guide. Best regarads. Tue, 04 Apr 2017 13:25:00 GMT https://community.blueprism.com/t5/Product-Forum/Sort-in-Excel-VBO/m-p/49691#M5049 asako_morimoto 2017-04-04T13:25:00Z https://community.blueprism.com/t5/Product-Forum/Sort-in-Excel-VBO/m-p/49692#M5050 Hi Mocha, I was perfectly able to sort the collection using Utility - collection manipulation. Just pass the column name in the sort field and there you go. And I you want to keep the top three lines jus put a decision box to check the condition for which you want to delete and you can delete the current row by using Internal Collections object Remove Row checking the condition prior to your deletion. Thanks. Sun, 09 Apr 2017 15:11:00 GMT https://community.blueprism.com/t5/Product-Forum/Sort-in-Excel-VBO/m-p/49692#M5050 GauravMittal1 2017-04-09T15:11:00Z