Greetings!
Please see my attached workbook. I am looking for assistance in creating a Macro that will grab all the data from the 'JulAugSep', 'OctNovDec', 'JanFebMar', and 'AprMayJune' sheets and dump it into 'Linked Sheet' starting at cell A2. Excel's consolidation option doesn't seem like the right solution because I'm not trying to sum, average etc the data; I'm simply trying to get everything from the Quarterly sheets into the Linked sheet, from which my Pivot table is linked to.
I've also tried, but have been unsuccessful at using the Pivot Table/Chart Wizard using Multiple Consolidation ranges to create a Pivot Table that incorporates all the quarterly data. I can articulate more on this if need-be.
Thank you.
Rick
Bookmarks