Multiple table in pivot table

**GilEytan** · 01-11-2016, 11:40 AM

I have 2 Listobjects (Tables) in a workbook,
i have one column in Table1 that have unique values (lets call it 'Key column')
i also have a foreign key column in table2.

i want to create a pivot table based on these two tables using VBA code.
taking columns from both tables to columns,rows,values and filters of that pivot.

how do i do that?

**NeedForExcel** · 01-12-2016, 05:07 AM

You have a couple of options -

1) As stated on your profile you are using the Excel 2013 Version, which has a Data Model where you can link Multiple Columns from different tables (Like a Join). After this, columns from both the tables will be visible under 1 Pivot. (VBA Not Required)

2) Use Vlookup and make a common table with columns from both tables, and then make the Pivot..

Multiple table in pivot table

LinkBack

Thread Tools

Rate This Thread

Display

Multiple table in pivot table

Re: Multiple table in pivot table

Thread Information

Users Browsing this Thread

Similar Threads

Pivot Table Conditional Formatting Dissappears / Pivot Table Leaves Colored Cells

creating a table that will link to a pivot table and change as the pivot table is changed

creating a table that will link to a pivot table and change as the pivot table is changed

Change Pivot Table Filter Based on Cell Value when Pivot Table is from an external Databas

Collapse/Expand - Pivot table Fields - Need equivalent option in Excel VBA Pivot table

Return pivot table range...not the data table, the PIVOT TABLE!

Multiple MS Access table sources for pivot table

Bookmarks

Bookmarks

Posting Permissions