Select a variable amount of Data with duplicate info

Hello Guys,

I have a question about writing a code that will save me a lot of time at work.

Basically we own some restaurants and our credit card processor changed the way they send us our credit card sales reports. Now they send us a report with every single transaction per day.

We need to sort this information by store number and by card type.

Here's what I am trying to do, I want to for example select all the Visa transactions for location 6693. I cant do a Vlookup because there are multiple transactions that have the same information I would look up (Location/Date/Card type)

Is there a way I can do this? Basically i just want this information to sort automatically, the problem is there isnt always the same amount of transactions per day per location per card type, so I just want it to be able to select all the transactions for that day for whatever card type and location, copy it, and paste into another sheet so I can easily get daily totals.

Right now we are having to filter each location and card type, separate them and add up the totals daily, we have over 25 locations so this is a VERY VERY time consuming procedure to do daily, I would appreciate any input or help even if its not in code, just a way I can sort all this information.

I am attaching a screen shot below of what the report looks like.

Column A - Store Number
Column B - Date
Column D - Card Type

\1
Untitled.jpg