I am looking for a macro which can ease my work of consolidating responses from different products/teams. I have attached a sample format.
I have to consolidate responses in column D, E and F in Column H. This action needs to be done from row no. 3 to 1000.
Here is the flow chart of the action I want to do with this macro:
- Check if cell C3 is having text. If yes, then copy its heading (in Bold with colon) in F3 and then its respective text. In case there is no text ignore and move to next column E.
- Check if column D3 is having text, if yes copy its heading (in Bold with colon) and its respective text in F3 under previous response.
- Perform similar action with E3.
I am not an expert with Macro's so I tried with Record macro. But that doesn't helps because I want to generalize this macro, meaning if I have more than one columns or may be different range of rows, I just change the column and row no. in the macro and use it further.
Please have a look to the attached file. I have tried to work with record macro and results are in column F3. In adjacent column H, I have given the format I desire.
Thanks in advance !!
Your support is appreciated !!