Can anyone help me with a solution to this query, preferably in VBA code:

I have a pivot table in a worksheet called "table", the user can select from the variable "board" which changes the view to reflect data (shown as "Activity" on the rows ) under each "board" in the raw data.
Along the X-axis of the pivottable are months - Apr-03 to May-05.

I have another worksheet which contains each "Activity" on the rows and months along the columns.

Is there a macro that would spin thru each "board" on the pivot-table and assign it to the correct row in the 2nd spreadsheet.
Happy to send you a mockup if anyone can help.

Thanks
Amy xx