Pivot table from multiple sheets

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Pivot table from multiple sheets

  1. #1
    New Member
    Join Date
    Nov 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pivot table from multiple sheets

     
    Hi everyone. I need some help creating a spreadsheet to calculate revenue from different businesses, and I want to keep all the data separate. But, I also want the data to interact with each other on one master sheet.

    There is also data that is the same across spreadsheets that it would be helpful to only have to enter once for each new entry.

    It's a bit complicated to explain out on one post but if someone is free to chat I would greatly appreciate the help.

  2. #2
    Board Regular pbornemeier's Avatar
    Join Date
    May 2005
    Location
    Virginia Beach, VA USA
    Posts
    3,453
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need help making pivot table from multiple sheets

      
    The Pivot Table Wizard that assists with this was easier to find in older versions of Excel. ALT+D P displays the PT Wizard and its option to combine data from multiple ranges.
    Last edited by pbornemeier; Nov 13th, 2017 at 11:13 AM.
    Phil

    - Use CODE tags to keep your code formatted. See: BB Tags
    - How to attach Screenshots
    - Try searching for your answer first, see how
    - Test and validate results for all code on a copy of your worksheet!! How do you use the code you just found?
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com