Hello,
I realize this will likely require an excel macro, but I'm not sure how to write this one...
I've got the following kind of data in one worksheet:
<tbody>
</tbody>
I would like to build a destination worksheet like :
<tbody>
</tbody>
Most of this content I have working, the only thing I cannot figure out how to do easily, is to populate the position column. I have several thousand rows, and no way to "group" by parent sku before creating the list, so I need some kind of either macro or formula to create an incremental value based on how many times the parent SKU is listed besides a SKU, and then show that sequence in the destination worksheet.
Thanks in advance.
I realize this will likely require an excel macro, but I'm not sure how to write this one...
I've got the following kind of data in one worksheet:
SKU | PARENT SKU |
OB1 | |
PR1 | OB1 |
FR3 | OB1 |
X8 | OB1 |
LT | |
IT1 | LT |
OI4 | LT |
LK-4855 | OB1 |
IT-9855 |
<tbody>
</tbody>
I would like to build a destination worksheet like :
code | SKU | Linked_sku | Position | QTY |
CP | OB1 | 0.00 | ||
CP | OB1 | PR1 | 1 | 0.00 |
CP | OB1 | FR3 | 2 | 0.00 |
CP | OB1 | X8 | 3 | 0.00 |
CP | OB1 | LK-4855 | 4 | 0.00 |
CP | LT | 0.00 | ||
CP | LT | IT1 | 1 | 0.00 |
CP | LT | OI4 | 2 | 0.00 |
<tbody>
</tbody>
Most of this content I have working, the only thing I cannot figure out how to do easily, is to populate the position column. I have several thousand rows, and no way to "group" by parent sku before creating the list, so I need some kind of either macro or formula to create an incremental value based on how many times the parent SKU is listed besides a SKU, and then show that sequence in the destination worksheet.
Thanks in advance.