I have a set of data which our team records (shown below) in order for us to upload it into another system we work with all lines based per month with value needs to be listed below each other (2nd table) how can I get VBA to do this???
<tbody>
</tbody><colgroup><col style="text-align: center;" span="6"><col style="text-align: center;"><col style="text-align: center;" span="2"><col style="text-align: center;" span="4"><col style="text-align: center;" span="4"></colgroup>
ok so for each month that contains a value greater than 0 per line, I need it to duplicate that line as shown below, can this be done?
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col></colgroup>
Class | Fpn | Mfr | Qty | Cost | Currency | Mpn | ReqDate(yyyy/mm/dd) | QuoteNumber | NOV | DEC | JAN | FEB | MARCH | APRIL | MAY | JUNE |
4B | lm317t | nsc | 0.65 | USD | lm317t | 1000 | 1000 | 1000 | 1000 | 0 | 0 | 0 | 0 | |||
4S | FM28V100 | cyp | 12.5 | USD | FM28V10 | 0 | 0 | 0 | 1170 | 1170 | 1170 | 1170 | 1170 | |||
4S | FM25V0 | cyp | 5.7 | USD | FM25V05 | 1164 | 1164 | 1164 | 1164 | 1164 | 1164 | 1164 | 1164 | |||
4B | 45LLTFITR | cyp | 0.6 | USD | 45ZXIT | 0 | 0 | 0 | 12000 | 12000 | 12000 | 12000 | 12000 |
<tbody>
</tbody><colgroup><col style="text-align: center;" span="6"><col style="text-align: center;"><col style="text-align: center;" span="2"><col style="text-align: center;" span="4"><col style="text-align: center;" span="4"></colgroup>
ok so for each month that contains a value greater than 0 per line, I need it to duplicate that line as shown below, can this be done?
Class | Fpn | Mfr | Qty | Cost | Currency | Mpn | ReqDate(yyyy/mm/dd) |
09 | lm317t | nsc | 1000 | 0.65000 | USD | lm317t | 2016/11/01 |
09 | lm317t | nsc | 1000 | 0.65000 | USD | lm317t | 2016/12/01 |
09 | lm317t | nsc | 1000 | 0.65000 | USD | lm317t | 2017/01/01 |
09 | lm317t | nsc | 1000 | 0.65000 | USD | lm317t | 2017/02/01 |
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col></colgroup>