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
35 freelanceria on tarjonnut keskimäärin 23 $ tähän työhön
I am a professional freelancer having expertise in MS Excel and I can complete your task effectively and efficiently in a timely manner. Portfolio: https://www.freelancer.in/u/KavTan.html
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.
Hey i can do this work for you.. i can move the entire row to open tab page by defining names ranges , and reference functions i have already done the data calling same like this ... you can trust me