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?