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:
<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>
</tbody>
Table B:
<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>
</tbody>
Please allow for Range Selection. Thanks for your suggestions.
Table A:
Category | Total Spend |
Merchandise | 5,642,042.62 |
Corporate Services | 9,054,819.94 |
Travel & Accommodation | 11,304,167.05 |
Support Costs | 61,560,281.01 |
Support Services | 95,534,059.06 |
Business Technology | 119,109,991.04 |
Table B:
Category | Total Spend |
Business Technology | 119,109,991.04 |
Support Services | 95,534,059.06 |
Support Costs | 61,560,281.01 |
Travel & Accommodation | 11,304,167.05 |
Corporate Services | 9,054,819.94 |
Merchandise | 5,642,042.62 |