Excel Macro to Compile one large file

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

Skills: Excel, Visual Basic

See more: macro compile files, excel macro large file, compile excel file, compile excel file macros, large excel macros file, macro compile csv, macro compile data excel files, compile large excel, me excel, uses for excel, excel uses, macro, macro excel, macro + excel, excel contains, multiple excel, visual basic compile, macros excel basic, excel row column, excel macro row, excel delete cell contains, excel macro csv, excel additional, excel delete row, excel column row

About the Employer:
( 41 reviews ) Staten Island, United States

Project ID: #1150718

Awarded to:


Hi jgarite, Please see PM for important information. Thanks, Jeff

$250 USD in 10 days
(4 Reviews)

7 freelancers are bidding on average $79 for this job


Looking forward to working with you...

$35 USD in 0 days
(59 Reviews)

Ready to start now...

$35 USD in 1 day
(74 Reviews)

Hi, please check your PM. Thank you.

$50 USD in 1 day
(26 Reviews)

Hi - please check your inbox. Regards, Mike

$80 USD in 5 days
(14 Reviews)

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.

$50 USD in 2 days
(18 Reviews)

Hi, I am expert in creating macro, automated applications and have 3+ yrs of Experience in advance VBA programming, I ll deliver you the quality work. I'll soon fix ur script. I am sure that you would be happy w More

$50 USD in 2 days
(3 Reviews)