Hi,

I've a set of data for the following:

Products 8/1 8/2 8/3 8/4 8/5 8/6 8/7
Plan Type A 0 0 0 60000 60000 20000 0
Result Type A 0 20000 0 40000 80000 20000

Using macros of the above Plan & Result
Output as below
Plan Result Diff Qty On schedule
Type A 8/4 8/5 -1 20000 20000
Type A 8/4 8/7 -3 20000 0
Type A 8/4 -999 20000 0
Type A 8/5 -999 60000 0
Type A 8/6 -999 20000 0

Note: -999 = No results

Thanks

S