How do I expand a table referencing a pivot table to match its dimensions?

I have a pivot table referencing a large database (20,000-30,000 rows) that pulls the results for a test my company provides. There can be anywhere from 1-15 rows within this database that correspond to a single client - the pivot counts each of them, categorizes them, and collapses everything into a single row. I have another table which references this pivot, converting the counts into some meaningful text, which is then referenced by another pivot, from which I pull my final results. Long story shorty, I'm set to hand this task off to another of my coworkers soon (woohoo!), but want to make the process a little less technical, as said coworker isn't as fluent in excel as I am.

I've been trying to create a macro that reads the number of rows in a pivot table and expands the table referencing it to match its dimensions. Honestly, VBA is new to me and I have slightly more than zero experience in programming, so any efforts I've made so far have been seemingly fruitless.  

How do I count the rows in the pivot?
Once I've done that, how do I expand the referencing table dimensions to match the count?
Finally, how do I make sure the formulas included in the referencing table are included in the new rows?

I attached an example of the setup I'm using, simplified & with stock data. Hopefully I provided enough information, but don't hesitate to ask for clarification!
Matthew StarrAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
How do you count the rows in the Pivot? By counting column E, and deducting one if you don't want the header, or two if you don't want the header and the total.

So, the number of rows can be =COUNT(E:E) or =COUNTA(E:E).

How do you expand the referencing table dimensions. By using OFFSET and maybe a named range.

I can't see the spreadsheet fully, but if Row Labels is in cell A2, then the data starts in A3. So the table might be:


or something like that.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.