How to remove a set of records once the product is no longer in inventory

[hjaten]

Good Morning,

     I am wondering if there is a formula to delete all records of "900068" if it contains a "Discard Weight" as noted in the last row of the table in order to avoid having to manually delete hundreds of records for all Product ID numbers.

9000068	Aatrexin	11/14/2019 12:23	25.8	Pre-Mix Weight
9000068	Aatrexin	11/14/2019 12:33	18.8	Post-Mix Weight
9000068	Aatrexin	11/15/2019 8:58	18.8	Pre-Mix Weight
9000068	Aatrexin	11/15/2019 9:01	13.8	Post-Mix Weight
9000068	Aatrexin	11/21/2019 14:43	13.8	Pre-Mix Weight
9000068	Aatrexin	11/21/2019 14:46	11.8	Post-Mix Weight
9000068	Aatrexin	11/21/2019 15:40	11.8	Initial Inventory
9000068	Aatrexin	11/21/2019 15:41	11.3	Post-Mix Weight
9000068	Aatrexin	11/22/2019 9:12	11.3	Pre-Mix Weight
9000068	Aatrexin	11/22/2019 9:22	0.8	Discard Weight

[#2]

@hjaten 

I think you can use VBA

simply apply a filter select the rows you need then delete them

here is my draft trial, please tweek it a bit

but it will work

[#3]

@Ramiz_AssafThank you! I will give this a shot and see what happens.