• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Consolidating several worksheets into one pivot table

Lilia

New Member
Hello,
I have 12 worksheets with the same data separated by months (each worksheet corresponds to a different month). This data changes every month.
Is there an easier way, other than creating a summary sheet to combine them all in one pivot table? And whenever I update one of the sheets all I have to do is refresh the pivot table?
Thanks,
Lilia
 

Attachments

  • Chandoo.xlsx
    300 KB · Views: 2
And what about the Data Model technique?

If the data on sheet Oct16, Nov16, Dec16 are in Tables then you can integrate these tables into 1 pivot table.

Or VBA.
 

Attachments

  • Chandoo.xlsb
    885.5 KB · Views: 3
Back
Top