Gregory has attended:
Excel Intermediate course
Excel VBA Intro Intermediate course
Excel Advanced course
Excel Advanced course
Creating a Hierarchy of Names
I am trying to create a list of names with the purpose ordering these in terms of 'experience'. The purpose of this being is that the more experienced you are, the greater amount of tasks you can full fill.
I imagine I would need to create a variable(s) that associates tasks with a number/index and then associate this index with each person and then organises them in terms of experience.
However, I am unsure of where to begin.
RE: Creating a Hierarchy of Names
Hi Gregory
Thanks for getting in touch.
Let me check that I understand your query:
* there are a list of tasks, which have a value for experience (so Managed a Project = 5, Completed Profit & Loss = 6 etc).
* you can then add these values together to give an accumulated "experience" score.
I'm not sure whether VBA is necessary for this outcome. Perhaps you could build a table in Excel, and use a VLOOKUP to query that table, returning the index associated with the task. Using a PivotTable on this summary data will probably give you the answer you need.
Check that I've understood the scope of your problem so far, and we can explore what you might need from here.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Creating a Hierarchy of Names
Hi Gary
Thanks for getting back so soon. In regards to my original question, I realised I did not explain in as well as I should have.
What I want to do is designate tasks out to a group of people. the problems I have are as follows;
i) Not everyone within the group can complete all the tasks required (some tasks are more advanced that cannot be completed by individuals in the group with limited experience)
ii)Each individual can only be assigned ONE task.
I think I have an idea using the FIND/MATCH function as well as a FOR NEXT LOOP.
Again I think this will require using variables as I want to rotate the tasks for each individual for say each week.
Cheers
Greg
RE: Creating a Hierarchy of Names
Hi Gregory
Thanks for your reply. You said you had an idea; would you be able to reply with the loose structure you have in mind?
I can then offer some advice how to refine this.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.