Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-01-2021, 03:17 AM
fabyoga fabyoga is offline Pivot with two different data sources Windows 10 Pivot with two different data sources Office 2019
Novice
Pivot with two different data sources
 
Join Date: Jul 2021
Posts: 1
fabyoga is on a distinguished road
Default Pivot with two different data sources

Hi,

I have a spreadsheet with two tabs:
1) sales numbers
2) expenses

For various reasons, it is very hard for me to keep these numbers in the same tab.

So my question is, can i create a pivot table, that can pull in the amounts from those two different tables?

I explain what I am trying to do in more detail in this quick screenshare:
Loom | Free Screen & Video Recording Software

Thanks in advance!
Reply With Quote
  #2  
Old 07-01-2021, 01:33 PM
Purfleet Purfleet is offline Pivot with two different data sources Windows 10 Pivot with two different data sources Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

can you upload the example workbook
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge - data sources Sarki76 Mail Merge 2 09-02-2019 01:28 AM
Pivot with two different data sources Not sure how to display this data in a pivot table makaveli80 Excel 8 04-04-2018 11:24 AM
Choosing Mail Merge templates and excel Data Sources using drop downs dushan997 Mail Merge 3 08-04-2017 07:54 PM
Copy and Paste mailmerge data sources in bulk iv_tavares Word VBA 3 05-18-2017 06:28 PM
Data gathering from varied sources for different outcome letters cs225 Word 2 10-19-2014 06:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft