Hello Everyone. I have been trying to find a solution on my vba issue for a number of days now. I tried searching in the forum but could not get it to work for my purpose. I am very much a newbie with VBA and the code I have been trying to put together is just so messed up now. Any help from anyone is very much appreciated.
Problem:
I have a worksheet with around 800 rows. The rows are basically an extract of PBIs and Tasks from TFS and they are already grouped together by Parent and it's corresponding child tasks. What I want to get from these records is to extract all of the Parent (PBI) row that is not = "Done" where ALL of its corresponding Child tasks are already set to "Done".
The Parent and Child records are identified as "P" and "C" respectively under the Level column. And all of the Child rows are numbered in sequence within each group.
Below is a snapshot of what my data looks like and what I am expecting as an output.
Apologies for the trouble and thanks in advance!
Problem:
I have a worksheet with around 800 rows. The rows are basically an extract of PBIs and Tasks from TFS and they are already grouped together by Parent and it's corresponding child tasks. What I want to get from these records is to extract all of the Parent (PBI) row that is not = "Done" where ALL of its corresponding Child tasks are already set to "Done".
The Parent and Child records are identified as "P" and "C" respectively under the Level column. And all of the Child rows are numbered in sequence within each group.
Below is a snapshot of what my data looks like and what I am expecting as an output.
Apologies for the trouble and thanks in advance!