Hi, Can anyone help me with this VBA code: I have attached a sample. Here is what I am hoping to accomplish: In Column A, anytime a specific "text" appears, I want to concatenate the information in the row, and place it into worksheet Data-list under a specific heading. Please forgive me if this question is not clear. I hope the sample page is easier to understand. Here is the link to the sample: https://drive.google.com/file/d/0B3y...it?usp=sharing The formula I would use (not vba) is =IF(A3="FN",B3,""), then I just copy it all the way down. However there are 27K cells, which is why I want a VBA Code.