Macro Help - Copy Data fro mmultiple CSV Files

[cbwilliams]

I need help creating a macro.

I have 10+ CSV Files and a single master excel 2010 file.
The CSV Files are updated by seperate individuals and I need to delete the contents of rows 8 until the end of the document.

I then need to copy the Data starting in A2 from the csv Files and copy it to C8 in excel.
I need to also Copy data starting at B2 from the csv and copy it to L8 in the excel file.

All other csv files should append the data. The CSV Files are also stored in seperate loaction.

Help is appreciated.

 

[dermie_72]

Do you have any code so far?

If you're unsure how to code what you want, then do the actions you want to do, while recording them with the macro record button in your excel.

If there are steps that you're usure of then you can either google those particular steps to expand your knowledge, or by reading any number of the VBA books that are available on this site.

If you have trouble with your code, and would like some guidance, please post what code you have, and Im sure there will be any number of people that can assist. </SPAN>