如果库存号相同且在sheet1中输入日期，则自动删除表2中的行？

Hello:) I need excel to automatically (thus vba would be preferrable) delete a row in Sheet2 if column D (stock number) for that row in Sheet2 matches the G column for any row in sheet 1 and if column AY's value for that row in sheet1 is a date. does anyone know how to do this? please let me know if i was unclear i would be happy to clarify further. thank you so much, eliasHello:) I need excel to automatically (thus vba