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
    Post Thanks / Like
    0 Post(s)
    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
    Virginia Beach, VA USA
    Post Thanks / Like
    0 Post(s)
    1 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.

    - 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

Some videos you may like

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