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
I have an image of my sheet, but I am not yet allowed to attach images to my post.
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
I have an image of my sheet, but I am not yet allowed to attach images to my post.