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.

this macro copies relevant row to sheet "past due"

modify if necessary

Please Login or Register  to view this content.

Thank you so much!

Lastly, is there any way to delete the entries that have been moved over in the original sheet?