VBA Write data from pivot to table on another workbook

[ELC774]

All-

I'm a VBA newb, so I thank you in advance for your assistance!

I am looking for VBA code that will take data from a pivot table in one workbook and write it to a table in another workbook. It gets a little more complex however...

The pivot table in the ClientRAWdata.xls workbook pulls from a changing data set. The ClientTrending.xls workbook is where I store the clients monthly spend each month. I need the code to add a column to the table then look up the company name from the pivot table, find it in the destination table and update the new column with the their total.

The table name in ClientTrending.xls is 'MRRtrend'.

Please let me know if you need any clarification or more information, any assistance would be greatly appreciated!