You can replace "SUNDRY EXPORT USD" with B5 (or some other cell address.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"winnie123" wrote:

Hi,

I have a list of customers in Column B and I would like to copy the value in
B2 to replace the end of a formula in Column c

The formula in column c is

=(GETPIVOTDATA("Sum of Qty",'Y:\Spares sales\[2008.xls]2008
Table'!$A$5,"Customer Name","SUNDRY EXPORT USD"))

The last bit of the formula SUNDRY EXPORT USD needs to change to whatever is
in Column B for the same row.

It it possible?

Thanks
Winnie