Organising Supervision Groups by Tutors by Stage

[MaverickGT3]

Hi All,

I'm not even sure this is possible and I can't even think of the phrase needed to investigate a solution so any support would be great.

I would like to take the information from the list in Stage 1 and include a Macro/VBA which would then organise the information for each Supervisor into Stage 2. Where each Supervisor is listed once and in their row is listed all the students they have working with them.

In my example James, Charlotte and Matt all have Supervisor 1, so Supervisor 1 would have 3 students in their row. While the rest of the Supervisors have 1 student. Supervisors could have up to 10 students each hence the columns for up to 10 students in Stage 2.

Any direction would be appreciated.

Gracias,

Maverick

[danielexcelvba]

Hi there, I think this should do the trick. You will have to enable Microsoft Scripting Runtime before you test it out. Go to the vba window > tools > references > enable Microsoft Scripting Runtime. Then run the code (there is also a test button on sheet 2 of the attached book). Let me know how it goes!

Please Login or Register  to view this content.

[MaverickGT3]

MY MAN! I've only had a chance to test is provisionally and not with all the data I use as I'm on holiday from today but it looks like it works.

Thanks again!!!!

[danielexcelvba]

No problem - glad I could help!