+ Reply to Thread
Results 1 to 3 of 3

Looking to consolidate data from multiple sheets into a pivot table

  1. 04-13-2018, 03:47 PM #1
    sabinap
    sabinap is offline
    Registered User
    Join Date
    04-02-2018
    Location
    Vermont, USA
    MS-Off Ver
    Microsoft Office 365 Business
    Posts
    8

    Looking to consolidate data from multiple sheets into a pivot table

    Happy Friday everyone!
    I am creating a document where I am looking to aggregate information about multiple Instagram "influencers" into one sheet that outlines their overall performance.

    I have attached a sample sheet, with the goals of the pivot table outlined on the KPI sheet.

    But essentially, each person will have posted several times about our brand and received multiple shipments. I want to aggregrate all information about each influencer (total engagements on posts, total cost of shipments, what the Cost Per Engagement is (Total Cost of Product/Total Engagements)

    I'd appreciate any guidance.
    Thank you so much!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-13-2018, 04:15 PM #2
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Looking to consolidate data from multiple sheets into a pivot table

    use Alt + D + P
    Reply With QuoteRegister To Reply
  3. 06-08-2021, 11:04 AM #3
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Looking to consolidate data from multiple sheets into a pivot table

    Does the attached help?
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to Summarize / Consolidate Data from Source Datas or One Pivot from multiple sheets
    By PMH2384 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-21-2016, 07:16 AM
  2. Consolidate multiple data ranges to an existing Pivot Table
    By cs02 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-11-2015, 02:48 PM
  3. Consolidate data (in table format) from multiple sheets into a single sheet (table format)
    By SaadShaikh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-13-2015, 06:23 AM
  4. Pivot table for Multiple data sheets
    By elqueso in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-03-2015, 10:00 PM
  5. [SOLVED] How to consolidate all data from multiple sheets into a master table.
    By marcusduton in forum Excel General
    Replies: 0
    Last Post: 02-26-2015, 11:55 PM
  6. Consolidate multiple worksheets for pivot table
    By MARKSTRO in forum Excel General
    Replies: 1
    Last Post: 03-19-2012, 02:50 AM
  7. [SOLVED] how do I consolidate multiple pivot tables into one pivot table?
    By pkahm in forum Excel General
    Replies: 0
    Last Post: 04-20-2006, 04:50 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1