Hi Rylo,

Thank you so much again!

I tried the revised VBA and it looks like it works correctly when the "Approved Date" is in Column A, and it erases data if I have other columns infront of the Approved Date. In my actual case I will have 2 additional columns in front of the Approved Date. Can you help again. Sorry for the trouble~