Filter a Pivot table based on cell in another workbook

Senerio

I am creating report that copies cells from a "read only" pivot table and paste them to a different worksheet. I need the "year" field in the pivot table to only show the year that the user imputs into a cell.

This is the code that I have now:

Please Login or Register  to view this content.

When I recorded he macro and manually choose 2011 this is what appeared

Please Login or Register  to view this content.

Unfortunately, I cannot post the workbooks because their content cannot be shared

HI nicknorth34, please re-read the forum rules located here and wrap your code in code tags as per Rule #3. Once you do that, someone will be able to help you.