Taking a list of tasks and a list of subtasks and creating a new list with groupings

Hi,

I've spent ages trying to figure this out but my VB aren't great and I'm not really getting anywhere

What I am trying to do is to take a list of tasks from one sheet, then take a list of sub-tasks (with references back to a task from the first list) from another sheet and create another list on the third sheet which lists all the tasks with each associated sub-task beneath each task, grouped.

I have attached and example of what I am trying to achieve. I would be really grateful for any help on this.

Thanks

Thanks Mike and John so much for the quick responses. Both of your solutions work great!

Originally Posted by jaslake

Hi kknb0800

Try this code...let me know of issues.

Hi John,

Quick question...in your code, how are you linking on the Key field in the "Tasks" sheet to Task Key field in the "SubTasks" tab when copying the data over to the "Tasks and Subtasks" tab? You seem to be sorting but I don't understand how it works

Thanks again

Thanks John for your help