Link two tables - one to contain select data from the other?

[russthedutch]

Hello board!
I am trying to figure out how I can get two tables to talk to each other but the second table only contain specific data.

I have a master dataset of transactions but I want to also have a separate table containing only one type of transaction so I can build summaries from it. This report will be used by a lot of colleagues and sometimes I won't be there to populate it and less-than adequately IT proficient colleagues will also be responsible for this report, so I have been asked to build it with as little clicks and code as possible (preferably none!)

I have managed to link two tables together and get the second to auto refresh, but as far as I've got simply filtering the table to view only the type of transaction I require still includes the other hidden transactions in my reports summary pages.

Basically, I'd like to highlight all data in the first tab, copy it to the second table and then delete everything that is not the transaction type I require, but I'd like to do this without all the manual steps, and get Excel to read only the specific data and pop it into the second table for me. Is this doable please?

Excel 2013 no access to power pivots or other activeX style functions, just the basics. Thanks.

 

[russthedutch]

Hi, I'm still no further with this - is it even possible? Thanks.