Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.