Hi.. I have made a pivot table.. that is working fine. Now i have to paste the values of a particular column (J) into another column (C) on the same worksheet. I am doing this simply by using "=" (equal to) sign. But the problem occurs when in the original spreadsheet i add or remove some values...