Summaries results in a filtered table

[russelldt]

I have a table (columns B to e) that is linked to a source excel file. The following code filters the data in Column C, to only display the relevant entries.

Private Sub Workbook_Open()
    With Sheets("Invoice log")
        .AutoFilterMode = False
        .Range("C3", .Range("C" & Rows.Count).End(xlUp)).AutoFilter Field:=1, Criteria1:=Sheets("Cashflow input").Range("E3").Value
    End With
End Sub

All goo.

Now I want to modify this script to summarize the Values that have been filtered, by the Name in column B.

 

[Peter_SSs]

When posting vba code in the forum, please use the available code tags. It makes your code much easier to read/debug & copy. My signature block below has more details. I have added the tags for you this time.


We have no idea what your data is like so if what I have below is no help what about a small representative set of sample data with XL2BB and explain the expected results in relation to that.

Does it have to be vba and is the filtering vba you already have there just to get the summary you are wanting?

If the actual AutoFilter is not required, could you use a formula approach like below? As best I can guess at this stage that is the sort of result you are after.

'Cashflow input' Range E3 contains the value 25.

russeelldt.xlsm
	B	C	D	E	F	G	H	I	J
3	Name	C	D	E		Name	C	D	E
4	Name 1	25	39	55		Name 1	75	81	160
5	Name 2	25	41	24		Name 2	75	112	100
6	Name 3	80	23	48		Name 4	25	70	58
7	Name 1	80	36	43
8	Name 2	25	29	38
9	Name 3	80	49	44
10	Name 1	25	27	80
11	Name 2	25	42	38
12	Name 3	80	29	33
13	Name 4	25	70	58
14	Name 1	25	15	25
15	Name 3	80	23	21
16	Name 3	80	80	17
17
Invoice log

Cell Formulas
Range	Formula
G4:G6	G4	=UNIQUE(SORT(FILTER(B4:B1000,C4:C1000='Cashflow input'!E3,"")))
H4:J6	H4	=SUMIFS(C4:C1000,$C4:$C1000,'Cashflow input'!$E3,$B4:$B1000,$G4#)
Dynamic array formulas.

If the requirement definitely is for vba then please confirm the sort of data and how it should be summarised (XL2BB is best again) as well as explaining where the summary should be.

 

[russelldt]

Thank you Peter

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.