Merging Multiple Tables Into One Summary

Pipeline tracking.xlsx

I have multiple tables all with the exact same header in multiple worksheets. Each worksheet is a region, pretty much, and what they would like is a summary page that simply takes anything from the region tables and places them in one summary table. I was trying to do it using combined range pivot tables but I don't want it to perform any calculations on the date, just combine them.

Hi,
You probably need a macro to do this but upload the workbook so that we can see the request in context.

Hi,

See the attached. Click the blue button. Every time the macro is run the summary is cleared and re-built hence you can freely delete Summary rows 3 onwards.

Regards

Hi,

You can create a pivot table from multiple ranges on separate sheet if you prefer.
Debrah Dalgleish has put up a YouTube video which you can reach from her web site here: http://blog.contextures.com/archives...ltiple-sheets/

I wouldn't call it a work around and in general you should always use standard Excel functionality in preference to VBA, but in this case I personally find the short macro far easier and much more flexible. For instance you won't need to add new ranges each time you add a new sheet, and it's just less hassle than building the pivot table ranges, particularly of you have many sheets and tables.

Regards

Hi,

No, your data is not really what Pivot tables are designed for. They're mainly for summarising and analysing data.

I was merely confirming the point that pivot tables can be constructed from ranges on multiple sheets, not that Pivot Tables are the way to go in this case. The macro is as I say far simpler and more future proof.

LizielBG,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.