PivotTable based on two work sheets

[TehJonny]

Hi,

Really hope someone can help me I have the spreadsheet attached here

I want to create a pivot table the same as what I have already created based on the combined TAB (which is just both In & Out Tabs combined to one i'd like to be able to do that without the need to have all the information on the same tab.)

https://mega.nz/#!50cl2SIJ!Qydb_vD-m-dXUHS_4ItynLFO241UOODKma1B48CnUfw


Many Thanks

 

[arunsjain]

Hi,

Refer to following useful link. Hope it will help

https://www.youtube.com/watch?v=NHNnnuOF8kU

 

[arunsjain]

Hi,

Follow the video in link above.

With use of power query, you can combine tables through connection and later close & load as pivot table on new worksheet. In future if you make changes in your data table (IN/OUT tabs) then just refresh all to refresh queries and the pivot table.

Hope it will help.

Cheers!!