Automatically Consolidate Data in Excel that has Multiple Duplicate Values

[Kiloelectronvolt]

Hi All,

So I just watched this video, and it did exactly what I needed it to do! However, I'd like it to do it automatically...

is there a way to make this data consolidate when I'm done typing, instead of clicking through the Data > Consolidate


THANK YOU!

 

[sandy666]

Try PivotTable or PowerQuery

 

[Kiloelectronvolt]

I'm no excel pro, but I tried making a pivot table for this, it worked, but didn't update after I created it.

 

[sandy666]

right click on PivotTable and select Refresh or use any VBA to refresh it automatically

eg.

Private Sub Worksheet_Change(ByVal Target As Range)
  Worksheets("Sheet1").PivotTables("PivotTable1").PivotCache.Refresh
End Sub