Results 1 to 8 of 8

Help with Macro to dump multiple sheets into one master sheet linked to Pivot Table

Threaded View

rickblasing Help with Macro to dump... 06-10-2015, 01:16 PM
PCI Re: Help with Macro to dump... 06-10-2015, 01:40 PM
rickblasing Re: Help with Macro to dump... 06-10-2015, 01:55 PM
PCI Re: Help with Macro to dump... 06-10-2015, 02:33 PM
rickblasing Re: Help with Macro to dump... 06-10-2015, 03:08 PM
PCI Re: Help with Macro to dump... 06-10-2015, 03:26 PM
rickblasing Re: Help with Macro to dump... 06-10-2015, 03:33 PM
PCI Re: Help with Macro to dump... 06-10-2015, 03:38 PM
  1. #1
    Registered User
    Join Date
    06-10-2015
    Location
    Wisconsin
    MS-Off Ver
    2010
    Posts
    4

    Help with Macro to dump multiple sheets into one master sheet linked to Pivot Table

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How do i make a master sheet linked to other sub sheets
    By cj22reyn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-05-2020, 12:21 PM
  2. [SOLVED] Macro to copy data from multiple sheets to one (new) master sheet
    By nhtodd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-24-2012, 02:30 AM
  3. 1018 sheets compiled into 1 master data dump
    By ryandurick in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-02-2012, 09:32 AM
  4. Replies: 1
    Last Post: 11-16-2010, 05:57 PM
  5. [SOLVED] sorting master sheet messes up cells in other sheets linked to it
    By Kt in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-30-2005, 07:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1