Hey Everyone,
So I have been trying to hone my coding skills, and discovered a pretty decent code to move rows of information from one sheet to another based on the word "Done" in the criteria column (using Autofilter)....BUT...I am running into some snafu's that I can't quite iron out.
The code i am using I borrowed from a previous thread, http://www.excelforum.com/excel-prog...ain-value.html, and here are the two problems:
1. I would like the last column (N) on the Progression sheet to automatically populate "Done" when a date is entered into the cell in column M. I used the formula =IF(ISBLANK(M2), "", "Done") which works only for the very first time I run the macro...the formula then stops functioning for some reason once new data is entered into the Progression sheet(event though the formula still exists in the cell). I know I could just drag and copy "Done" for the cells I want it to apply to, but I am trying to automate the experience for the users.
2. The second minor issue is that the Autofilter on the Progression sheet will not shut off at the end of the macro. I thought I had the appropriate code line, but that is not the case.
Please see the code below and the attached spreadsheet. Thanks everyone!
Bookmarks