Johnathannn
New Member
- Joined
- Oct 25, 2019
- Messages
- 2
Hello,
I am looking for VB code to copy data from one sheet, and paste it onto another sheet in a different format.
Here is the current format:
<colgroup><col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;">
<col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 3218;" span="5">
<col width="137" style="width: 103pt; mso-width-source: userset; mso-width-alt: 5010;">
<col width="79" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;">
<tbody>
</tbody>
Here is the desired format (on a new sheet):
<colgroup><col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;">
<col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 3218;">
<col width="64" style="width: 48pt;">
<tbody>
</tbody>
Thanks!
I am looking for VB code to copy data from one sheet, and paste it onto another sheet in a different format.
Here is the current format:
ID | Amount 2014 | Amount 2015 | Amount 2016 | Amount 2017 | Amount 2018 | Total Previous Years | Grand Total |
001 | 2066.1 | 4438.73 | 6703.19 | 10705.06 | 5785.5 | 23913.08 | 29698.58 |
003 | 1166.12 | 2985.56 | 6071.15 | 8415.4 | 4548.04 | 18638.23 | 23186.27 |
187 | 779.83 | 661.34 | 0 | 0 | 0 | 1441.17 | 1441.17 |
010 | 1226.74 | 3155.46 | 6352.5 | 8693.07 | 5027.26 | 19427.77 | 24455.03 |
006 | 0 | 0 | 0 | 2543.51 | 3297.14 | 2543.51 | 5840.65 |
011 | 181.28 | 702.5 | 4463.38 | 6080.35 | 2715.44 | 11427.51 | 14142.95 |
007 | 1170.04 | 2952.28 | 5011.27 | 8757.77 | 4548.04 | 17891.36 | 22439.4 |
032 | 734.12 | 325.95 | 3220.54 | 7080.43 | 3156.4 | 11361.04 | 14517.44 |
Here is the desired format (on a new sheet):
ID | Years | Amount |
001 | Amount 2014 | 2066.1 |
001 | Amount 2015 | 4438.73 |
001 | Amount 2016 | 6703.19 |
001 | Amount 2017 | 10705.06 |
001 | Amount 2018 | 5785.5 |
003 | Amount 2014 | 1166.12 |
003 | Amount 2015 | 2985.56 |
003 | Amount 2016 | 6071.15 |
003 | Amount 2017 | 8415.4 |
003 | Amount 2018 | 4548.04 |
187 | Amount 2014 | 779.83 |
187 | Amount 2015 | 661.34 |
187 | Amount 2016 | 0 |
187 | Amount 2017 | 0 |
187 | Amount 2018 | 0 |
010 | Amount 2014 | 1226.74 |
010 | Amount 2015 | 3155.46 |
010 | Amount 2016 | 6352.5 |
010 | Amount 2017 | 8693.07 |
010 | Amount 2018 | 5027.26 |
006 | Amount 2014 | 0 |
006 | Amount 2015 | 0 |
006 | Amount 2016 | 0 |
006 | Amount 2017 | 2543.51 |
006 | Amount 2018 | 3297.14 |
011 | Amount 2014 | 181.28 |
011 | Amount 2015 | 702.5 |
011 | Amount 2016 | 4463.38 |
011 | Amount 2017 | 6080.35 |
011 | Amount 2018 | 2715.44 |
007 | Amount 2014 | 1170.04 |
007 | Amount 2015 | 2952.28 |
007 | Amount 2016 | 5011.27 |
007 | Amount 2017 | 8757.77 |
007 | Amount 2018 | 4548.04 |
032 | Amount 2014 | 734.12 |
032 | Amount 2015 | 325.95 |
032 | Amount 2016 | 3220.54 |
032 | Amount 2017 | 7080.43 |
032 | Amount 2018 | 3156.4 |
Thanks!