Hi,

I have a pivot table, that i am running code on to name the column totals
based on the criteria in the Pivot table. We have a Name, and what it
relates to, i.e. cars purchased would be JohnSmithCarsPurchased. I have a
front end for this with the individual headers and the names, i.e.
A B C
Cars Sold Cars Bought
John Smith HERE

In the front end i want to put a formula concatenated by the name and the
section, ie.

= (A2 & B1) for JohnSmithCarsSold

Hope this is clear.

Thanks

Nathan.