Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an excel workbook that has three pivot tables in it. What I am wanting to do is create a fourth table that combines the data from all three of the other tables.

Essentially I want to concatenate the tables together but still preserve the source tables.

Another criteria of what I am wanting to do is if I add a row to any of the source tables it must update the combined table and it must work with x amount of rows where x could be any size.

I know I am asking a lot but I would be so grateful if I could get some help working this out. I am comfortable with using either VBA or native excel to solve this.

If you guys need examples I will be happy to upload some.

share|improve this question

Perhaps you could move the data into database tables, perhaps using Microsoft Access, perhaps using something better. You could then use those database tables as data-sources for the Excel worksheets.

share|improve this answer
I found a solution using VBA – Samuel Nov 15 '10 at 17:55
Perhaps you could post the answer here (and accept your own answer) – RedGrittyBrick Nov 15 '10 at 18:03

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.