SUMIFS VBA taking very long time

  • HI,

    i tried kind recording Macro for the SUMIFS, however its taking very very long time to run the report, just to summarize, there are total three macros two macros to lookup the values based on the specific criteria in a table (From Magento and OMS workbooks) and the 3rd Marco to run the reconciliation.

    While running the 3rd Macro the excel is almost getting stuck. i have data which goes more than 200,000 lines or more

    Is there any suggestions to improve the code.

    kindly advise.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!