could anyone help me write macro to open allexcel files from a folder and copy certain rows and paste all details in a new excel sheet line by line.


Thanks..