Forum Discussion

Jairaj15's avatar
Jairaj15
Copper Contributor
Sep 19, 2020

Dividing quantities by inserting rows

I am currently facing a challenge on one of my excel report which is basically used for formatting Sales order lines in order to upload on ERP (Baan). Basically, I get data for the 'x' part for 100...
Formulas and Functions
Macros and VBA
  • Jairaj15's avatar
    Jairaj15
    Copper Contributor
    Sep 21, 2020

    Ramiz_Assaf Hi ,

    Its not a shipment, Its a sales order creation template for upload in ERP.

    Please find attached example for your reference.

     

    Basically I have given qty ordered in PO by customer and accordingly we need to split them in ERP  by lines for SO.

      • Jairaj15's avatar
        Jairaj15
        Copper Contributor
        Sep 21, 2020

        Thank you so much 

        Its solving my problem. Just a question, is it going to work if i have multiple rows to be split like more than 100 rows?

Resources