NotASuperGenius
Board Regular
- Joined
- Jun 17, 2002
- Messages
- 62
Good afternoon. I am collaborating on an XLS that has tabs representing multiple product lines(lets say products Red, Blue, and Gold). Each product manager has prioritized the 2021 projects for their product via the WSJF methodology (see link). I need to copy all projects from all the tabs with a score above 10 to a new tab (lets say the tab is called "Plan") that is intended to represent what will be worked on in 2021. I have been doing this manually, but I wondered if it could be automated. When Red, Blue, or Gold tabs are changed that Plan tab gets automatically updated with the projects that have a WSJF above 10. Bonus points if the Plan tab stays sorted by WSJF value. Thanks in advance for any thoughts or advice - NASG