I have a pivot table on sheet1 where field "month" is in area page,fields,"emplooyes" is in area row field , "working hours", "vacation","seek-leave" and "work on sunday" is in area data fields.
On the sheet2 I make table
emplooyes january february marth
Now, I want write a cod who will looks emplooyes on the sheet2,month in pivot table and range pivot table. If month is january cod will copy "working hours" and paste only value in column January, if month february cod will copy
in column february and ect.
I try with function Vlookup.
In the column January on the sheet2 I put following formula
=Vlookup($A2;sheet1!$A$5:$E$56;3;false)
It is ok!, but when I change month in the pivot table change value on the sheet2 in column January.
Thank you,