up vote 0 down vote favorite
share [g+] share [fb]

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.

link|improve this question
feedback

1 Answer

up vote 0 down vote

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.

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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