Hello,

I have a primary worksheet with defined named ranges. I reference
these named ranges with about 10,000 SUMPRODUCT formulas on a secondary
worksheet. The formulas all reference the same two defined columns,
"Application", and "Date".
The problem is that whenever I add rows of data to the primary
worksheet, the secondary worksheet seems to be running all 10,000 formulas,
and the performance is slow.
Is there a way to write VBA scrip or something so that the secondary
worksheet will only run the formulas applicable to the current date, like a
GetDate( ) function that SQL has? This would reduce the number of running
formulas from 10,000 to 25, and the performance would be greatly enhanced. I
could theoretically use such a Getdate ( ) and equate it to a value in the
"Date" column, like to run the formulas if "Date" = GetDate ( ). Any ideas?
Thank you in advance for any help that anyone can provide.

John