Returning multiple txt Substrings and using them as search term

[DAN_AO]

Hi Guys,

I've attached an example of a document I need some help with. I've tried a ton of different things but keep getting stuck.

I'm trying to search for string(s) of text in a cell, extract them into a single cell as headers then use them as a search term to return info from elsewhere in the work book.

Hopefully the attached demonstrates what I need to achieve, I've tried to keep it as simple as possible.

This is well beyond my ability to conceive but I should be ok to run with it if someone can give me a starting point?

Thanks a lot

[jindon]

For the data/layouts provided.

Please Login or Register  to view this content.

[DAN_AO]

Wow quick reply and it works perfectly!! Thanks a lot.

[jindon]

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[DAN_AO]

I have one more quick question. Please can you let me know the area's I need to amend if I wanted to change sheet names or switch from FIND to another word?

[jindon]

As I mentioned, the code was written specifically for that particular workbook provided.

If the sheet names are different, I need to re-write the code.

[DAN_AO]

Ok this attachment is very close to the real life spread sheet. I thought I was helping before by simplifying. Anything you can do what be seriously helpful. Even if you just mark In the code where you define things and I'll try and figure it out. Appreciate your help.

[jindon]

Now confusing.

I can not find the logical relation between "Users" and "Summary".

[DAN_AO]

Summary is just a mock up of how I'd like the results to look - It's the same as the Results tab In the last version but with one extra Column.

Users is the source of names and data access profiles for each person. There's no significant relation between them.

[jindon]

I was trying to find the logic to derive the "summary" from "users" but I don't think I understand it.
So please wait for someone else to come in to help you.