Don,

The 'exact cells' could have GETPIVOTDATA functions...

HTH,
Bernie
MS Excel MVP

Thanks. I was going to use a pivot table but I am contrained. The
figures have to plug into a stagnant report shell that is integrated
into other applications with hard codes to exact cell references so
unfortunately the flexible nature of a pivot table does not work.