Event Macro that Triggers Cut/Paste

Hello all,

I am a complete beginner in Excel VB, and I searched around the forum and the below thread is the closest example I can find.

http://www.excelforum.com/excel-prog...o-another.html

Essentially I'm trying to do is make Excel pull rows of data which have the "End Date" older than 10 days from today from worksheet1(datalog) to worksheet2(pastdue).

I tried looking at the previously mentioned thread's examples and looked into the code view but I still have no idea.

If anyone could help me, I would be so grateful.

Thank you.