Macro to execute Sumifs furmula faster

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED

AddFile.jpg

To add a file to a post

Hi Everyone,

I attached an excel file which I hope it can demonstrate the problem.

The main objective is to match items based on various criteria located in different columns. I have created various "SUMIFS" depending on these criteria. All matched items are marked as "YES" and then user will opt to move out the items to different sheet.

My problem is, at the time if copying the sumif formula, it takes very long time and sometimes excel will no longer respond.

I use the below code to update/copy the SUMIF function to all rows for one of the criteria. This code is repeated with different criteria and cell where the formula is copied from.

Please Login or Register  to view this content.

I hope someone can find solution.