Hi Team,
Can anyone assist me with macro code in order to get the required output. I have unique product criteria, the moment I select this product in the below example as Product Z, I need get another 3 (fixed common products) products should populate in the below row wth respective of qtys, if qty says 3 then other three products should be double the unique product qty.
Plz refer the below example for more information...
Input:
Name Qty
Product Z 3
Ouput:
Name Qty
Product A 6
Product B 6
Product C 6
Your inputs really much appreciate....Thank you
Can anyone assist me with macro code in order to get the required output. I have unique product criteria, the moment I select this product in the below example as Product Z, I need get another 3 (fixed common products) products should populate in the below row wth respective of qtys, if qty says 3 then other three products should be double the unique product qty.
Plz refer the below example for more information...
Input:
Name Qty
Product Z 3
Ouput:
Name Qty
Product A 6
Product B 6
Product C 6
Your inputs really much appreciate....Thank you
