I have a set of macros that are currently cleaning up multiple workbooks. I need the code optimized so that it will run as fast as possible.
I have a problem with the macros though. When I tried copying a cell from C2 for example, down to the last cell that has data in column A, the macro uses a set number. The problem is that the number of rows can vary from day to day. In an effort to workaround this, I tried setting a fixed number far beyond the number of rows that I knew would exist, for example 20000. Then I found some code that would delete a row that contains blank cells. This takes a long time and is creating problems. There are about 30 different files altogether that need to, in the end, be 1 file. The estimated number of rows in the end should be about 85,000-90,000, including a header cell at row 1.
If you can optimize the code to perform better (while keeping in mind that additional workbooks will be added as time goes on) and get the final code to output a single csv file, then please help me. Thank you
7 freelancers are bidding on average $79 for this job
Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement. See previous projects that i have delivered.