Search Column A Concatenate Row and place in New Worksheet

The link doesn't work. Upload your workbook here. I guessed on a lot of stuff so try this. It will put the concatentated stuff in column A of the Data-list sheet:

Please Login or Register  to view this content.

Thank you stnkynts. The FN transfers over with concatenate, but this is definitely close to what I am needing, so your guessing was dang spot close. Did my sample worksheet make more sense?

Kind Regards,
Ami

The only difference I can see is that my code would need to paste the concatenated stuff in column B instead of A and some sheet name changes:

Please Login or Register  to view this content.

Thank you very much.

How might I include multiple searchers? For example if I want to search for "F" and place that in column C and "ADR" place in Column D?

Code question: is rcon and rcell the same?

How do I remove the FN because so it reports only the concatenate data without the search criteria?

Like this I would think:

Please Login or Register  to view this content.

How might I include multiple searchers? For example if I want to search for "F" and place that in column C and "ADR" place in Column D?

Well, we could set up an array but if you only have a few search parameters it would be quickest to just copy and paste the autofilter code then change the criteria1 and the output. See below:

Please Login or Register  to view this content.

Code question: is rcon and rcell the same?

No.

Thank you very much for the help.

Since I am not confident with arrays, I will stick to copying and pasting The Code you gave me to remove the search criteria worked like a charm.

Sincere Appreciation!