Need help with making live connection. IMPORTANT!!!

[nardella35]

I have a master table that contains 955 rows with 10 Columns (Case No., Invoice No., Date of Charge, Category, App. Type, Country, Attorney, Foreign Firm, Cost, Year). There are 9 categories and 14 countries. I want to make a new table that is connected to this master table but is ONLY made up of Case No., ONE OF THE CATEGORIES (OFFICE ACTION), App. Type, ONE OF THE COUNTRIES (US), Attorney, Cost. I have tried filtering the master table and copy and paste special. I have TRIED a pivot table, it is what I wanted, but I have to do a vlookup, and you can't do that w/in a Pivot Table. When I say connected, I mean that when I change the master table, it would change the table that is created. This is really important and I would take any help. THANK YOU!!

 

[dermie_72]

pivot table would be best. If you need to vlookup, then add the vlookup to the main data before you create the pivot table.
You can filter the fields you want which should provide the information you require.