The following Sub asks the user to select a generic template to open, then asks the user to select a source file (to populate the template). The source file is contains a number of worksheets and pivot tables. The sub then selects data from a pivot table and copies it into the template.

I need the source file to be a variable vs. a hard coded pivot table source bc this title changes based on the users selection.

Problem: when the data is copied it only shows REF! instead of the actual data (even when the data is present). 

Please Login or Register  to view this content.