Complex filter (or macro) of CSV file

[mrstoked]

Hello,

Every day I have to download a CSV file, convert it to XLSX and then I have to do a complex filter and I'm wondering if there is a way to do this automatically.

The CSV files always have the same format and layout of columns and headers but the content is different.

Here's a screenshot:

And I need to filter these columns:

I >= 10
K >= 10
L >= 10

But really complicating things is this last filter:

K / L <= 2

Is this possible since there would be two filters on one column? Also, I'd like to save the "macro" or whatever I need to make this work separate from the file.

Thanks!

 

[mhillmann]

Well I can give you a simple way to separate them.

Sub HideRows()
Dim intRow as Integer
Dim intLastRow as Integer

intLastRow = ActiveSheet.UsedRange.Rows.count

For intRow = 2 to intLastRow
     If Cells(intRow, "I") < 10 OR Cells(intRow, "K") < 10 OR Cells(intRow, L) < 10 OR Cells(intRow, "K") / Cells(intRow, "L") > 2 Then
          ActiveSheet.Cells(intRow).EntireRow.Hidden = True ' You can change this line if needed
     End If
Next

End Sub

This will hide the rows that you don't want and you can copy and paste the ones that you do. Or if you want to change the noted line to delete or something similar that will work as well.

Hope that helps.