Perhaps you can set up a table with your plan numbers, then use the
GetPivotData function to pull data from the pivot table. There's
information in Excel's Help, and here:
http://www.contextures.com/xlPivot06.html
> How to compare some fixed numbers with pivot numbers ? In details:
> - I have some allocations = volumes to sell = my plan = fixed numbers
[quoted text clipped - 18 lines]
>
> Juraj

Signature
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html