Thanks Cory for your response, but Each excel file (or should i say CSV file) contains around 200,000 to 1,000,000 rows.
I dont think excel program will allow me to create two sheets each one with that many rows, thats why i thought only a macro will do this job.
quick question: do you know how to create a keystroke : CTRL + F ? is it <ctrl><f> ?