Brand new to VBA and very lost on if this is possible.
I have a CSV file with over the limit of how many rows excel can handle. I know that in my data there are many rows that have no information in them at all.
I was wondering if it was possible to create a macro which can read the file and find the rows which have the data as there are only around 200, 000 rows with data, instead of reading in the whole file with over 1.2 million rows.
So for example if column B, C and D are 0 then do not read the row into the worksheet.
The first row is the column headings which i would like to keep, but from then on i would like it to find the rows which match the criteria.
Is this possible?