Filter based on latest date and other criteria

[EslamTM]

Hi everyone,

I've below dataset and I would like to filter it based on the latest date for each company of the amount, how to do that using vba?

Thanks

value_date	Company name	fc_trs	Balance
21/08/2022 0:00	Company 1	671025​	671025​
20/07/2022 0:00	Company 2	800000​	800000​
28/07/2022 0:00	Company 2	800000​	800000​
08/08/2022 0:00	Company 2	800000​	800000​
16/08/2022 0:00	Company 2	800000​	800000​
21/08/2022 0:00	Company 3	600000​	600000​
24/05/2022 0:00	Company 4	2500000​	2500000​
16/08/2022 0:00	Company 4	2500000​	2500000​
20/02/2022 0:00	Company 5	462780​	462780​
28/04/2022 0:00	Company 5	462780​	462780​
05/06/2022 0:00	Company 5	462780​	462780​
26/06/2022 0:00	Company 5	462780​	462780​
06/07/2022 0:00	Company 5	462780​	462780​
21/08/2022 0:00	Company 5	462780​	462780​
17/04/2022 0:00	Company 6	1500000​	1500000​
18/08/2022 0:00	Company 6	1500000​	1500000​
21/08/2022 0:00	Company 7	202150​	202150​
31/12/2021 0:00	Company 8	236.98​	236.98​
10/08/2022 0:00	Company 9	0.6​	0.6​
11/08/2022 0:00	Company 10	826244.7​	826244.7​