Hi Excel Guru's..need a vba to resolve this.
Below table is my Onedrive source Data Set residing in Sheet1 (Table 1 )
<tbody>
</tbody>
I want a vba to convert above data set into below format (Table 2) pasting in same book under sheet2, but only for new entries done in Table 1
Sub ID will be generated based on Asset column : if value exists in Asset2 or Asset3, a new row is generatd below under same ID. If Value is Null in Asset2 or Asset3 then the array moves to next ID item line.
<tbody>
</tbody>
Using VBA MACRO Button.
I appreciate your time and efforts.
Please write if you find any difficulty to understand.
Regards
Centaur
Below table is my Onedrive source Data Set residing in Sheet1 (Table 1 )
ID | ST | NAME | Asset | Qty | UOM | Asset2 | Qty2 | UOM2 | Asset3 | Qty3 | UOM3 | Asset4 | Qty4 | UOM4 | Asset5 | Qty5 | UOM5 | Req type | Justy | Enclose |
1 | 16-07-19 | xyz | top | 5 | 100 | rock | 8 | 80 | soft | 10 | 110 | Form | Yes | |||||||
2 | 16-07-19 | abc | rock-h | 9 | 40 | soft | 6 | 70 | No |
<tbody>
</tbody>
I want a vba to convert above data set into below format (Table 2) pasting in same book under sheet2, but only for new entries done in Table 1
Sub ID will be generated based on Asset column : if value exists in Asset2 or Asset3, a new row is generatd below under same ID. If Value is Null in Asset2 or Asset3 then the array moves to next ID item line.
ID | Sub ID | ST | NAME | Asset | Qty | UOM | Req type | Justy | Enclose |
1 | 1.1 | 16-07-19 | xyz | top | 5 | 100 | Form | Yes | |
1.2 | 16-07-19 | xyz | rock | 8 | 80 | Form | Yes | ||
1.3 | 16-07-19 | xyz | soft | 10 | 110 | Form | Yes | ||
2 | 2.1 | 16-07-19 | abc | rock-h | 9 | 40 | No | ||
2.2 | 16-07-19 | abc | soft | 6 | 70 | No |
<tbody>
</tbody>
Using VBA MACRO Button.
I appreciate your time and efforts.
Please write if you find any difficulty to understand.
Regards
Centaur