Hi,
I am looking for a VBA script to copy row A2 to H2 if K2 has a value if K2 is blank then nothing.
For example
<colgroup><col style="width: 71pt; mso-width-source: userset; mso-width-alt: 3437;" width="94"> <col style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730;" width="102"> <col style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;" width="67"> <col style="width: 48pt;" width="64"> <col style="width: 75pt; mso-width-source: userset; mso-width-alt: 3657;" width="100"> <col style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;" width="86"> <col style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;" width="67"> <col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" width="70"> <col style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;" span="2" width="67"> <col style="width: 71pt; mso-width-source: userset; mso-width-alt: 3437;" width="94"> <tbody>
</tbody>
I am looking for a VBA script to copy row A2 to H2 if K2 has a value if K2 is blank then nothing.
For example
Column A | Column B | Column C | Column D | Column D | Column F | Column G | Column H | Column I | Column J | Column K |
Product name | company name | Date | Item number | Serial Number | Product type | Color | Period | Unit required | ||
A | B | 100 | 1020 | 601 | Green | One week | 4 | |||
B | A | X | 102 | 1010 | 600 | Blue | 3 days | |||
Result | ||||||||||
Column A | Column B | Column C | Column D | Column D | Column F | Column G | Column H | |||
Product name | company name | Date | Item number | Serial Number | Product type | Color | Period | |||
A | B | 100 | 1020 | 601 | Green | One week | ||||
B | A | X | 102 | 1010 | 600 | Blue | 3 days | |||
A | B | 100 | 1020 | 601 | Green | One week | ||||
A | B | 100 | 1020 | 601 | Green | One week | ||||
A | B | 100 | 1020 | 601 | Green | One week |
<colgroup><col style="width: 71pt; mso-width-source: userset; mso-width-alt: 3437;" width="94"> <col style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730;" width="102"> <col style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;" width="67"> <col style="width: 48pt;" width="64"> <col style="width: 75pt; mso-width-source: userset; mso-width-alt: 3657;" width="100"> <col style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;" width="86"> <col style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;" width="67"> <col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" width="70"> <col style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;" span="2" width="67"> <col style="width: 71pt; mso-width-source: userset; mso-width-alt: 3437;" width="94"> <tbody>
</tbody>