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
Bookmarks