to filter by criteria and calculate sum and display in next workbook

[rshnkmr39]

I have Brand,item,region and revenue in columns a,b,c and d respectively
each brand has multiple items and each item sells in multiple regions
My objective here is to Filter for a brand-item combination and calculate the sum of the revenue at all regions
take the range as a1000,b1000,c1000,d1000
the output should be displayed in the next workbook as

Brand Item 200000
Pepe jeans 500000

i.e brand item duplicates need to be removed and sum to be displayed alongside


Thanks in advance

[oeldere]

Use a pivot table for that job.

[rshnkmr39]

I want the same with the help of a VB Code in the next workbook..Since i want to create a macro ..i do not want to refresh the pivot each time the input changes..

[oeldere]

What's the problem with refreshing a pivot table?