Creating a list of tasks and their subtasks...

Ok, I have attached a sample workbook of what I am trying to do, I have a number of different tasks that have a number of subtasks associated to them. The "Matrix" sheet has the main tasks down Column A and the subtasks across Row 2, the matrix in the middle shows which subtasks are associated with the task by use off ticks (P in the Wingdings 2 font!). Now I would like to have a new sheet created listing in Column A the task number, column B the task description then in column C a list of the sub tasks associated with this task - as per the example...


I can do most of this but need help with the best way of seeing if there is a tick, and if there is transfrering the description of that subtask to the new sheet. Any help would be great!

Hi

Put in a new sheet called sheet1, then see if this will do.

Please Login or Register  to view this content.

If it is OK, then reset the output sheet to be your desired sheet.

rylo