I want to create a live list of all incomplete from my current excel file. Each week is a new tab such as Week of Feb 6, Week of Feb 13, Week of Feb 20 and so on. Each of these tab has a running list of task that will be marked as open or close. The goal is to have all the task that are marked as open appear in a separate named "Open Items".
How could I program my excel sheet to create live list of all the items marked as "Open"? I have tried using and if statement, but I can't figure out how to move the entire row to the "Open Items" tab.
I have an image of my sheet, but I am not yet allowed to attach images to my post.
Potential responders could make some money on this at freelancers https://www.freelancer.com/projects/...pert-13138029/
were it not for the fact that there is already a solution at http://stackoverflow.com/questions/4...-task-in-excel
Cross posted without links
josht50m, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184