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. Thank You
33 freelancers are bidding on average $29 for this job
I have sound experience (5+ years) in Excel/MS Access/Data Entry and Visual Basic for Applications development and ability to learn new task quickly. I am efficient and Trustworthy.