I want to reference a pivot table with an autosizing Data Table

[Nirvana67]

Picture a three column Pivot Table (Call Type, Date, and Calls Received). Right next to it I have a Data Table directly referencing the Pivot Table, an exact copy. Is there a way to make the Data Table autosize for when the pivot adds rows to the bottom? I am using the Data Table to add to a Power Pivot Data Model, and it won't let me directly reference the pivot table.

 

[mole999]

If you pivot is in A1 (for instance) then reference that cell in G1 (allow room for expansion) as =If(A1="","",A1) and only display the values when they exist

 

[Nirvana67]

Yes, I could do that, but I would have to run the formulae way down the page, which would add unnecessary size to the file. Seems like there would be a way to do what I am looking to do.