How can I write a VBA that will copy Table A and paste it as Table B (see below).
Please allow for Range Selection. Thanks for your suggestions.
Table A:
[TABLE="width: 201"]
<colgroup><col width="161" style="width: 121pt; mso-width-source: userset; mso-width-alt: 5888;"> <col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <tbody>[TR]
[TD="width: 161, bgcolor: transparent"]Category[/TD]
[TD="width: 107, bgcolor: transparent"] Total Spend [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Merchandise[/TD]
[TD="bgcolor: transparent"] 5,642,042.62 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Corporate Services [/TD]
[TD="bgcolor: transparent"] 9,054,819.94 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Travel & Accommodation[/TD]
[TD="bgcolor: transparent"] 11,304,167.05 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Support Costs[/TD]
[TD="bgcolor: transparent"] 61,560,281.01 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Support Services[/TD]
[TD="bgcolor: transparent"] 95,534,059.06 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Business Technology[/TD]
[TD="bgcolor: transparent"] 119,109,991.04
[/TD]
[/TR]
</tbody>[/TABLE]
Table B:
[TABLE="width: 201"]
<colgroup><col width="161" style="width: 121pt; mso-width-source: userset; mso-width-alt: 5888;"> <col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <tbody>[TR]
[TD="width: 161, bgcolor: transparent"]Category[/TD]
[TD="width: 107, bgcolor: transparent"] Total Spend [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Business Technology[/TD]
[TD="bgcolor: transparent"] 119,109,991.04 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Support Services[/TD]
[TD="bgcolor: transparent"] 95,534,059.06 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Support Costs[/TD]
[TD="bgcolor: transparent"] 61,560,281.01 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Travel & Accommodation[/TD]
[TD="bgcolor: transparent"] 11,304,167.05 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Corporate Services [/TD]
[TD="bgcolor: transparent"] 9,054,819.94 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Merchandise[/TD]
[TD="bgcolor: transparent"] 5,642,042.62 [/TD]
[/TR]
</tbody>[/TABLE]
Please allow for Range Selection. Thanks for your suggestions.
Table A:
[TABLE="width: 201"]
<colgroup><col width="161" style="width: 121pt; mso-width-source: userset; mso-width-alt: 5888;"> <col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <tbody>[TR]
[TD="width: 161, bgcolor: transparent"]Category[/TD]
[TD="width: 107, bgcolor: transparent"] Total Spend [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Merchandise[/TD]
[TD="bgcolor: transparent"] 5,642,042.62 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Corporate Services [/TD]
[TD="bgcolor: transparent"] 9,054,819.94 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Travel & Accommodation[/TD]
[TD="bgcolor: transparent"] 11,304,167.05 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Support Costs[/TD]
[TD="bgcolor: transparent"] 61,560,281.01 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Support Services[/TD]
[TD="bgcolor: transparent"] 95,534,059.06 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Business Technology[/TD]
[TD="bgcolor: transparent"] 119,109,991.04
[/TD]
[/TR]
</tbody>[/TABLE]
Table B:
[TABLE="width: 201"]
<colgroup><col width="161" style="width: 121pt; mso-width-source: userset; mso-width-alt: 5888;"> <col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <tbody>[TR]
[TD="width: 161, bgcolor: transparent"]Category[/TD]
[TD="width: 107, bgcolor: transparent"] Total Spend [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Business Technology[/TD]
[TD="bgcolor: transparent"] 119,109,991.04 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Support Services[/TD]
[TD="bgcolor: transparent"] 95,534,059.06 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Support Costs[/TD]
[TD="bgcolor: transparent"] 61,560,281.01 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Travel & Accommodation[/TD]
[TD="bgcolor: transparent"] 11,304,167.05 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Corporate Services [/TD]
[TD="bgcolor: transparent"] 9,054,819.94 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Merchandise[/TD]
[TD="bgcolor: transparent"] 5,642,042.62 [/TD]
[/TR]
</tbody>[/TABLE]