I want to show my tasks in lists based on priority based on the Eisenhower matrix.
I sourced a spreadsheet online which did this using macros. But its problematic.
I have attached the file.gh_user_Activities.xlsm
Can someone help make the following improvements:
1/ make it work without macros, if that can be done (so I can modify later if needed...I dont know how to use macros)
2/ remove some of the extra functions (to add tasks and remove completed tasks, as I can just do this in the 'To do list table'
3/ for tasks shown in the matrix, also show in (brackets) who is Lead and in [ ] target date if these are specified (sometimes they wont)
4/ remove limit in matrix which only covers 50 tasks. I have about 120 I need to manage & prioritise
5/ remove scroll bars in matrix as not helpful if I want to print
Hope you can help