Moving rows of data automatically

[jamesplant1977]

Hi.

I was hoping you may be able to help me with a macro for the attached spreadsheet?

I want to be able to do the following:

1. Upon opening the spreadsheet, any rows that have a status of completed, will be removed and pasted to the completed tab.

2. Upon opening the spreadsheet, any rows that have yes, in the added to lessons learned log field, will be removed and pasted to the lessons learned tab.

I am quite new to excel, so would welcome your help!!!

Thanks