A client is in a bind and I need an immediate answer. Im googling and such but if anyboyd could help it would be awesome. I have a batch file that is being imported in Excel.
Here is the thing, the batch file has order info. If they order 3 items, the order will be listed on a single row, with product quantity column saying 3. I need to script it so that it will look at the product quanity for each line and if its >1, it will duplicate the row as many times as listed in product quantity, and change product quantity to 1.
Thanks!
JK
Here is the thing, the batch file has order info. If they order 3 items, the order will be listed on a single row, with product quantity column saying 3. I need to script it so that it will look at the product quanity for each line and if its >1, it will duplicate the row as many times as listed in product quantity, and change product quantity to 1.
Thanks!
JK
Facebook
Twitter