![]() ![]() I put the Current time in the flow as a way to work out when it was dumped so i can see which is a duplicate. All I can get so far is the dump of all my tasks over and over so they duplicate everytime the flow runs. This is the flow i have now which does not fully work as it fails when it comes to the Row ID im not sure how to set that field to get it to always look at all the rows and update all of them. I can create a macro to erase info from the spreadsheet every day or use Excel to hide information with a certain date stamp but that becomes difficult to manage and rather clunky. so everyday I get a fresh dump of what is on my planner board without it doubling up in the spreadsheet. The catch is I also need it to Update or at least delete the old information. What I wish to do is have all my tasks from Planner populate an Excel spreadsheet which will everyday dump what my tasks are. I need to have all Planner tasks that are assigned to me available for my manager to quickly look at so they can see my current workload without having to dig through Planner itself. ![]() You can set any alphabet of your choice as a short cut key. (Or you can also simply skip this step and press the Alt key with the F8 key to open up Macros) STEP 5. Next go to Tools, then go to Macro, then go to Macros. I am having trouble trying to find a way to make Excel more dynamic. Open your Excel sheet once again, Click on Enable Macros, if prompted. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |