Moving rows of data automatically

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

In my opinion, then best time to do these changes is when you CLOSE the workbook so the updates you've just completed cause the workbook to "move data" as the workbook is closing. When you open it next, those changes will have already be done.

Open the VB editor and paste this macro into the ThisWorkbook module:

Please Login or Register  to view this content.