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.
thanks
aleem