I need a way to carry out a sumifs that will loop through multiple worksheets in a workbook. |
I have a worksheet named "Summary". This worksheet will list every worksheet that exists in the workbook and will be created on the fly based on a workbook event |
I need the Macro to look down Column A, starting at A7 of the Summary tab and find each of the tabs that exist in the workbook then carry out a sumif based on criteria listed in the Summary Tab |
I need two different Sumifs calculations |