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
[TABLE="width: 740"]
<tbody>[TR]
[TD]Contract/Product/Region[/TD]
[TD]On Off[/TD]
[TD]On Off[/TD]
[TD]Tranding [/TD]
[TD]Tranding [/TD]
[TD]Contra[/TD]
[TD]Contra[/TD]
[TD]timing[/TD]
[TD]timing[/TD]
[TD]Comments[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Column E[/TD]
[TD]Column F[/TD]
[TD]Column E[/TD]
[TD]Column F[/TD]
[TD]Column E[/TD]
[TD]Column F[/TD]
[TD]Column E[/TD]
[TD]Column F[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]east[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]west[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]north [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]south[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Column D[/TD]
[/TR]
</tbody><colgroup><col><col span="8"><col></colgroup>[/TABLE]
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
[TABLE="width: 740"]
<tbody>[TR]
[TD]Contract/Product/Region[/TD]
[TD]On Off[/TD]
[TD]On Off[/TD]
[TD]Tranding [/TD]
[TD]Tranding [/TD]
[TD]Contra[/TD]
[TD]Contra[/TD]
[TD]timing[/TD]
[TD]timing[/TD]
[TD]Comments[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Column E[/TD]
[TD]Column F[/TD]
[TD]Column E[/TD]
[TD]Column F[/TD]
[TD]Column E[/TD]
[TD]Column F[/TD]
[TD]Column E[/TD]
[TD]Column F[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]east[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]west[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]north [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]south[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Column D[/TD]
[/TR]
</tbody><colgroup><col><col span="8"><col></colgroup>[/TABLE]