I would like to know how to copy a variable cell value in a pivot table from one sheet to another. 
I would like to copy Sum X Est from label Buy and S. The code must work even if there is a row missing of data.
I tried GetPivotData("labels", C1, "Buy", R2, "S", R3, "Sum X Est.", C2) but it does not work from one sheet to another sheet and copy-paste cannot be used as the data in the columns may vary with data i.e., sometimes variable Buy S can be there or not be there.
Can anyone please help me to find a solution to the issue?
I would like to copy Sum X Est from label Buy and S. The code must work even if there is a row missing of data.
I tried GetPivotData("labels", C1, "Buy", R2, "S", R3, "Sum X Est.", C2) but it does not work from one sheet to another sheet and copy-paste cannot be used as the data in the columns may vary with data i.e., sometimes variable Buy S can be there or not be there.
Can anyone please help me to find a solution to the issue?
