Hi all,
new here and need some help. I tried to find some by searching but still no good answers.
To my problem; I got large .csv files with about 30-40000 rows. In column "A" and "E" I got some diffrent numbers that I want to find and copy to a new workbook (Book1.xls).
So my condition is that I want to find 1501 in column "A" and 216 in "E", if these to are right then copy to Book1.xls Sheet1. If column "A" is 1503 and "E" is 216 then copy to Book1.xls Sheet2.
My next problem is that I need to do this with my next .csv file but condition are changing column "A" is the same but "E" will be change to 554 or 559, and I want these to be copied from first empty row after my first problem
Can someone help me in right direction? I have no problem to copy files into my excel document and delete the rows I don't want, but with two of these .csv files i will get alot of rows so I hope to only get the rows I need copied to right sheet.
Thank you if anyone can help me!
new here and need some help. I tried to find some by searching but still no good answers.
To my problem; I got large .csv files with about 30-40000 rows. In column "A" and "E" I got some diffrent numbers that I want to find and copy to a new workbook (Book1.xls).
So my condition is that I want to find 1501 in column "A" and 216 in "E", if these to are right then copy to Book1.xls Sheet1. If column "A" is 1503 and "E" is 216 then copy to Book1.xls Sheet2.
My next problem is that I need to do this with my next .csv file but condition are changing column "A" is the same but "E" will be change to 554 or 559, and I want these to be copied from first empty row after my first problem
Can someone help me in right direction? I have no problem to copy files into my excel document and delete the rows I don't want, but with two of these .csv files i will get alot of rows so I hope to only get the rows I need copied to right sheet.
Thank you if anyone can help me!
