Automatically Move Completed Tasks to an Archive (with Excel Office Scripts & Power Automate)

Join 300,000+ professionals in our courses: https://www.xelplus.com/courses/ Learn how to use the "record actions" button in Excel Automate tab and record an Office Scripts. With Office Scripts we'll create a macro that works on both Excel desktop and Excel online. In this example, I'll show you how to create a script to automatically move rows from one sheet to another sheet every single day. Many of us have to maintain and update task or to-do lists in Excel. Wouldn't it be nice if tasks marked as "Complete" or "Done" are moved to an Archive automatically at the end of each day. So, next time you open the task tracker only open tasks are shown on your to-do list? For example, you've created an Excel table to collect all the tasks your team is working on. At the end of the day, you want to move all the "Complete" or "Done" tasks to another Excel table. Instead of doing it yourself every single day, you can fully automate it. I'll show you how to create an Office Script to move rows from one table and append it to the bottom of another table based on a logic. I'll also show you how to let the script run automatically at a scheduled time using Power Automate. We'll set up a flow that runs the script every day. This way you don't need to worry about running the script yourself. Power Automate will run automatically. With this tutorial you'll get to learn both Office Scripts and get an introduction to Power Automate and how to create a flow from Excel. ? My Online Courses ► https://www.xelplus.com/courses/ You can download the script and file here: https://github.com/LG-Experiment/Scripts 00:00 Move All Rows with Status Finished Into Another Worksheet 02:00 The task tracker 03:40 Record Actions with Office Scripts 05:23 Testing the Recorded Script 06:20 Understanding Office Scripts Code 07:14 Office Scripts to copy visible range in table 08:28 Append rows to the bottom of a table with Office Scripts 11:17 Loop through a table and delete table rows with Office Scripts 15:12 Power Automate to run the script every day 18:18 Optimize and Debug Code 19:31 Wrap Up ? LINKS to related videos: Introduction to Office Scripts: https://youtu.be/fny4zUycp_w How to use Office Scripts and Power Automate to do Boring Excel Tasks for You: https://youtu.be/v-_joMcPpLI ?☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ ? Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ ? Excel RESOURCES I Recommend: https://www.xelplus.com/resources/ ? GEAR I use: https://www.xelplus.com/resources/#gear More resources on my Amazon page: https://www.amazon.com/shop/leilagharani ?Let’s connect on social: Instagram: https://www.instagram.com/lgharani Twitter: https://twitter.com/leilagharani LinkedIn: https://at.linkedin.com/in/leilagharani ? This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #officescripts #powerautomate #excel

Видео Automatically Move Completed Tasks to an Archive (with Excel Office Scripts & Power Automate) автора Excel Анализ качества продукции