Need assistance with Marco

[tinkerv102]

I have 38 excel files that I am looking to compile into one on a weekly basis. The files are all with the same format and the first 9 rows are the header to the file. My goal is to essentially copy and paste all the data from the 32 files beginning at row 10 for each into one. I have attempted to record my macro to see if it could duplicate my functions but somewhere after the 5 or 6th copy and paste the files gives an error. Could anyone assist me in coding a consolidating macro for the process.

The files would all be consolidated into a report called " Consolidated PPA reports" and the files that I am looking to consolidate are within a sharepoint path (does it need to be a path housed on the desktop to function properly?)

Any help would be greatly appreciated.

 

[annieexcel]

Can you post the code you're using?

 

[tinkerv102]

Hi Annieexcel, I originally attempted to just record the macro itself and do the manual process and it was not working out when it came to the output. I then attempted a few different versions of consolidation macros I found online and those did not help much.

 

[annieexcel]

I just think you might be more likely to get help if you post that code where things were going wrong around the 5th or 6th copy.