I have an Excel workbook where is needed to remove all rows wherever appears a 0 value in a certain column before adding it into a collection (see attached picture as an example: When column D contains 0 value, that row must be deleted).
I tried these actions with MS EXCEL VBO 1.Get Cell value - 2. Is zero? - 3.Remove Row but it's very time consuming (about 200.000 rows in the excel sheet)
So i was wondering if there is anyway of doing it with an additional code stage passing as input de column in excel where to chech is values are equal to 0. My programming skills are not very good so i'm having problems into find this solution.
Also, a macro cannot be executed in this case.
Thank you all for your help.
I tried these actions with MS EXCEL VBO 1.Get Cell value - 2. Is zero? - 3.Remove Row but it's very time consuming (about 200.000 rows in the excel sheet)
So i was wondering if there is anyway of doing it with an additional code stage passing as input de column in excel where to chech is values are equal to 0. My programming skills are not very good so i'm having problems into find this solution.
Also, a macro cannot be executed in this case.
Thank you all for your help.