Hello ExcellentAmanda,
Try the following code in the "Report Tracking" sheet module:-
I've used the sheet codes in the above macro (Sheet1 and Sheet2) so I'm assuming that "Report Tracking" is Sheet1 and "Archive" is Sheet2.
Once you enter "Yes" in any cell in Column AH and click away (or press enter or down arrow), the relevant row of data will be transferred to Sheet2 (Archive). The row will then be deleted from the Report Tracking sheet.
With this code, the criteria "Yes" is case insensitive.
To implement the code:-
- Right click on the "Report Tracking" sheet tab.
- Select "View Code" from the menu that appears.
- In the big white field that then appears, paste the above code.
I hope that this helps.
Cheerio,
vcoolio.
Bookmarks