Sort and Move

J

josht50m

New member
Joined
Feb 17, 2017
Messages
1
Reaction score
0
Points
0
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.
 
Potential responders could make some money on this at freelancers https://www.freelancer.com/projects/php/would-like-hire-Excel-Expert-13138029/
were it not for the fact that there is already a solution at http://stackoverflow.com/questions/42298685/creating-a-list-of-incomplete-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
 
You must log in or register to reply here.
Back
Top