Listing values into one cell based on a status...

Hi everyone,

I've been tasked with editing our Excel spreadsheet for test cases.

I've attached the template to help illustrate what I'm trying to do.

On the main worksheet (which is the summary), I'm trying to list the test case #'s from the Requirements worksheets (1 for each requirement) that have 'Blocked' or 'Failed' status. However, I'd like the test case #'s to all be displayed in 1 cell as there will potentially be 100+ test cases for each requirement.

Is this even possible? I'm completely new to the macro/VBA world. I've always just used the sheets, but now I'm being asked to make the sheets more usuable.

After I figure this one out, I'll have to figure out why the Generate Matrix button from the Traceabilty Matrix is including some of the information from the test case section...

And then I'll have to figure out how to copy cells A1:L14 and paste it into the next available row, and have the Num auto generate to the next number....

Wow...I have a lot to figure out...