Newbie here. Macro functions but extremely slow

Hello All!

I have had so much help with these forums and was wondering if someone could help me with my macro. I am a civil engineer with no programming knowledge. Most of the vba macro I created is by using codes from this forum or by recording in excel and extending it a little further. It has worked so far however it takes hours and hours to process all the files. I now have a folder with over 600 files that I have to process and I have let it run overnight and it has successfully however I cannot present it to the users since it is time consuming. Couple of specific issues that I as a non-programmer can mention is:

1. Module 37 is the master list of all the macro I use --- I dont think this has any issues
2. Call one is pretty straight forward - it imports all the csv like files into the current workbook -- Don't think this has any issues
3. Call two (module 6) - calculates average speed and uniformity metrics. --- This is the one I think has major issues. Since the data is variable, I did not know how to mention "check for rows with values and calculate average". Instead, I calculate average of full columns or sometimes specific cell numbers which in this case I set it as 3600 rows. Then all the calculations are done cell by cell since I recorded macro and generalized. This macro takes a ton of time.

4. Module 29 also is recorded and is time consuming.

5. Module 33 is also recorded and takes time to copy and paste formula cell by cell.


I was wondering if anyone out here could help/ guide? I have attached the macro for your reference. Thanks in advance!

Sarah

That was super quick. thanks! I will try that and see if it speeds up. I am not sure if I have to hire a pro to rewrite the full code because processing 77 files took 28 minutes. And some folders have over 600 files!

Thanks, Norie! It did help to an extent. I hope I can make similar adjustments to other macros to speed it up further. Thanks! Any other pointers, anyone ????

www.ozgrid.com/forum/showthread.php?t=191169

Hi, Norie! Thanks for the note. I could not attach a file in the reply so here is the link to the sample files.

dropbox.com/s/sxkrlhmtsxopnev/NE.zip?dl=0 In the main tab I input the path to the (extracted data) folder and the macro should run. Thanks again for your time and help!

Here are the cross post links at other places:

mrexcel.com/forum/excel-q...ent-macro.html
excelforum.com/excel-prog...mely-slow.html
ozgrid.com/forum/showthread.php?t=191169