Concatenate Cells Based on a Condition in Next Row

You can try this code

Please Login or Register  to view this content.

I assumed the values are in column A and B

Thank very much! That is a great start. I have a couple simple questions for you.

-How do I change it from column "B" to column "E" to search for a match?
-How do i change it to reference a cell on another sheet? (This macro will run on "Sheet1" and for information on "sheet2" and ouput in a cell on "sheet1")
-How do i change the "TOM" match to reference another cell where the search query is located? (again the cell is on "sheet1" for data on "sheet2")

I obviously need to learn the basics. Anyone know a good book or place to start?

I guess anyone could help me with these fixes if they understand the code sidhus wrote.

Thanks

Modified the code. Assuming Name column is in sheet2-A column, Approver is in Sheet2-E Column.
Search criteria (TOM) is in sheet1-A1, Output is written in Sheet1-B1

Please Login or Register  to view this content.

Originally Posted by brendanec

Thank very much! That is a great start. I have a couple simple questions for you.

-How do I change it from column "B" to column "E" to search for a match?
-How do i change it to reference a cell on another sheet? (This macro will run on "Sheet1" and for information on "sheet2" and ouput in a cell on "sheet1")
-How do i change the "TOM" match to reference another cell where the search query is located? (again the cell is on "sheet1" for data on "sheet2")

I obviously need to learn the basics. Anyone know a good book or place to start?

Thank you so much for your help. This works perfectly and has taught me a lot.

1 final request - is it possible to remove the last ";" from the output?

from:
"tom;alex;mark;steve;"

to:
"tom;alex;mark;steve"

Thanks!