Excel - Putting Tasks into Priority Matrix

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
Thanks
gh_userAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Roy CoxGroup Finance ManagerCommented:
There's no attachment
gh_userAuthor Commented:
Thanks Roy.  have tried again to upload
Roy CoxGroup Finance ManagerCommented:
I've found two examples, this one doesn't require macros/

Excel Task matrix
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Roy CoxGroup Finance ManagerCommented:
The one that you have attached is the other one. What problems do you have with it?
gh_userAuthor Commented:
Hi Roy.  The main problem I have is the limitation in the number (50 or less) of tasks it will show in the matrix, plus the scroll bar
I also would like to see the name of lead and target date in the matrix if such has been specified.
Roy CoxGroup Finance ManagerCommented:
The first scroll bar is 40, the other three are 45. I think they are not necessary but increasing to 100 is a quick fix. I've adjusted them to 100 and adding the lead to the UserForm won't be difficult and likewise the date.
Roy CoxGroup Finance ManagerCommented:
I've added the Lead for you. I would rather add my DatePicker for the date than relying on manual input. I'm out for the most of today but I can add that later if you want.


I haven't had time to check what needs amending on the spreadsheet in formulas to display the Lead & Date, but check these changes and I'll check back when I get home.
gh_user_Activities--1-.xlsm
Roy CoxGroup Finance ManagerCommented:
I've added a calendar to pick the date.

The lead and date are added to the list. Check it out and let me know if you need any changes

I think the code can be improved and I'll look at that later.
gh_user_Activities--2-.xlsm
gh_userAuthor Commented:
Hi Roy
Thanks for this. Really appreciate your help.
Just some comments:
a/ I couldnt see the lead and target dates in the matrix
b/ I expanded the to do list to 70 but couldnt see tasks beyond row 53 in the matrix
c/ I couldnt see the calendar function.  But thats OK. ... as target dates may vary from blank, month, year, specific date, depending on the task.  So need the flexibility.
d/ If you have time, could you also remove some of the extra functions and associated buttons (to add tasks and remove completed tasks) as I can just do this in the 'To do list table'

Thanks in advance
Roy CoxGroup Finance ManagerCommented:
I've dded the calender and lead to the userform for adding them to the to do list.

Using the form I have added Task G which appears in the Task Matrix, unfortunately the author of the workbook hasn't put formulas in to add lead & data to matrix, I'll have to look at the formulas
Roy CoxGroup Finance ManagerCommented:
I'left the code in but can remove it if you want.

Check the Task Matrix now, it shows Task, Lead & Date. Also, it should store up to 100 Tasks
gh_user_Activities--2-.xlsm

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gh_userAuthor Commented:
Thanks Roy.
Thats great.
2 Questions:
1/ Why the need for the 'To Do List Sorted' sheet, and what is it sorted on?
2/ I'm going to use it for volunteer work I'm working on where I am getting others to help me.  SO A BIG THANKS AGAIN.  I'll will need to add more columns in the To Do List sheet so more info. about tasks can be added.  Is there anything I should beware of that may break the good work you have done?
Roy CoxGroup Finance ManagerCommented:
I'm not sure why the author introduced the sorted list when the data could be input directly there. Currentlt it is populated by formulas from the To Do List.

Add any columns to the right of the existing data if possible.

I will try to see if the workbook can be streamlined.
gh_userAuthor Commented:
Thanks Roy
If you are tinkering with workbook, I have attached a copy with the extra columns I needed shown, as it didnt work out just adding them to the right.  Can you work on that one?gh_user_Activities-3.xlsm
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.