I am new to Excel formulas/VBA and am not sure if my problem can be solved with simple formulas, or if a VBA solution is better.
I have csv files located in separate tabs, coming from various surveys taken over time. I want to compile all the comments from these surveys into a separate "Comments" tab. In the csv file, I need to search the column containing the questions (Column B), looking for those requesting comments. Once found, I want to copy the comments, which are located in column C, into the "Comments" tab. This tab will contain each of the questions along with the growing list of comments.
Any advice in accomplishing this task, would be greatly appreciated.