Hi
I need help in VBA coding
I have region wise different excel worksheets and on each sheet in column D there are some comments and in Column E and F I have values against which there are certain headers in column H
Now I want to collect all the comments from column D and values from column E and F and populate it in a new sheet region wise and append it under different headers which are there in column H
so that all the comments are placed vertically region wise under different headers
<tbody>
</tbody><colgroup><col><col span="8"><col></colgroup>
I need help in VBA coding
I have region wise different excel worksheets and on each sheet in column D there are some comments and in Column E and F I have values against which there are certain headers in column H
Now I want to collect all the comments from column D and values from column E and F and populate it in a new sheet region wise and append it under different headers which are there in column H
so that all the comments are placed vertically region wise under different headers
Contract/Product/Region | On Off | On Off | Tranding | Tranding | Contra | Contra | timing | timing | Comments |
Column E | Column F | Column E | Column F | Column E | Column F | Column E | Column F | ||
east | Column D | ||||||||
west | Column D | ||||||||
north | Column D | ||||||||
south | Column D |
<tbody>
</tbody><colgroup><col><col span="8"><col></colgroup>