Hey all,

I am new to VBA programming so thanks for the help early on. Attached you'll find the sheet I am working with.


I am using a sumproduct formula instead of using an array formula. The problem I am having is that the calculation process is extremely slow. I was wondering if there was a way to use VBA to look at the names on the "weekly" worksheet and then perform the sumproduct (or a formula that does the same thing) formula that is currently there.

It could also be the formula that I am using that is causing the sheet to run so slow.

Any help would be greatly appreciated.

Best,
TExcel Help.xlsx