I have 2 workbooks with the same layout €“ one contains weekly details of
Project Resource 'Requirements' (in days) and the other one contains details
of Team Resource 'Availability'

Name Project 01/01 08/01 etc€¦
Fred P1 3 2

I would like to compare the 'Requirements' with the 'Availability' and
calculate the variation ..

Name Project 01/01 08/01 etc€¦
From WB1 Fred P1 3 3
From WB2 Fred P1 4 2
Variation +1 -1

I tried producing a Pivot Table from the combined sheets but the results are
incomprehensible.. any thoughts on how this might be achieved would be
gratefully received €¦.

--
Thanks and have a good day

Ruth