Linking data from Pivot Tables

[new2VBA!]

Hi,

I need to link data from a pivot table to cells in a different workbook. This is not a problem. The Problem is that cells that the data is linked to are for each day of the year, and the pivot table the data comes from can be sorted by Month and day. Each Month the pivot table will be updated to show only data for that current month, this will cause the data that is linked to the cells in the different workbook to change. How can I prevent this from happening. There are way to many lines to copy and past, I am looking for away to make this more efficient.

I have also thought about expanding the pivot table to show all months but this will not work as it will be to large, and other people will have to use the same pivot table for other items.

Is there a way to get what I want without having to copy and past ? Is there something I could do in VBA ?

Please Help....

 

[uson]

Hi new2vba,

I saw your post and thought this would answer my question. How do I link data from a pivot table in Wookbook2 to data in Workbook1? Say in WB1 I have the named range "Sales" defining the field in the pivot table, I'd like to point the pivot table in WB2 to WB1 and have the tables able to refresh as needed. Sounds like you got that part working. Care to share how?

Thanks