Removing completed work from main sheet to monthly tab automatically when date inserted to column i

New workbook for new job my employer is looking for the completed work to disappear from the master sheet that has all our outstanding work onit and automatically appear in the correct month completed tab along the bottom once the date completed is added in column I. So when I enter the date say 01/04/2017 in column I the this row should move from the first sheet to the tab labelled April 17. so therefore only leaving outstanding work on the very first sheet. I know I will have to use macros but its been soo long since I have used them I have completely forgotten. any help would be much appreciated.

Answer the Question

You must create an account to use the forum. Create an Account or Login