I have put together a workbook that contains a mixture of macros and the use of complex nested if statements. The workbook is set up so that the macro adds a specific amount to one cell then that cell flows to another worksheet. In the other worksheet, the changing numbers created by the macro effects a large array of complex nested if statements. The source of the inefficiency is the nested if statements that play off each other in large array in which the cells must constantly interact due to the number change in the other worksheet.

So, in short, a macro changes a value using a loop until statement that then cascades through a large array of nested if statements. Each time the value changes the nested if statements must refresh resulting in an unacceptably slow macro.

PLEASE HELP.

Thanks in advance!