Finding text in another cell with more text.

Hello guys,

i have an excel which will be used by testers.

They will add pages ($login,$home,$spectacles) to the excel, then they will input the controls used (users,names,emails,passwords)

In the next excel you will see from C11 to C36 , the pages that the tester will input, from D11 to D36 the web elements or controls that they will use... eg: users,passwords if they used only that data.

This is in the sheet 1, in the sheet 2 i want to:
1) scan the used pages
2) generate them in the sheet as A2 and A6 (sheet 2)
3) next to them show the controls used (listed , dropdown).


I attached the excel, it has some things in spanish but they are irrelevant, also Sheet and Hoja are the same .


Thanks guys!!

You get better help on your question if you add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

[... deleted bacuse OP changed all information from first post...]

Why not just filter the data.

See the attached file.

Hey guys, rules have changed, now i can use a list.

I will upload the excel,

ignore the second sheet,

Now you should see "Page Objects" in the lower part of the excel, the blue one.
next to it there should be "controls used"
I need to list: IF the Page Object used was $login, list all the page objects used with login

if login - passwords was used, add password to the list, so then the analyst will click the list and see all the used page objects.


Another thing, i know some C#,AS3,Javascript etc, but Visual Basic is too different, so if i knew how to do it in VBA i would do it
I would do it with a 2D array checking row by row