date based delete

[mani_singh]

hi i have a large set of data, with a data in column a & column e & some text in column F

i need macro to remove rows where the date in col a is earlier than 6 months before the date in column e & column f has the text "a/g or "g"

thanks

 

[mani_singh]

i'm sorry about that, long day