Insert line where value in colume M exceeds value in column AC and some

[HelpExcelForum]

Hello Excel Forum,

I have a spreadsheet with multiple columns. Column M states the number of boxes required to be despatched per that product. Column AC states the maximum boxes that can be stacked on a pallet. I am unsuccessfully trying to create code that do the following;

If value in column M exceeds value in column AC amend the value in column M to the value in column AC and then create a duplicate line below for the remaining boxes.

Repeat process until column M value less than or equal to column AC value. Loop through all part codes.

As an example...

Original file...
Line No. Column B Column M Column AC
Part Boxes Ordered Max Pallet Qty

1 ABC123 22 8


File post VBA...
Line No. Column B Column M Column AC
Part Boxes Ordered Max Pallet Qty

1 ABC123 8 8
2 ABC123 8 8
3 ABC123 6 8


Hopefully my ramblings above make sense, any help would be massively appreciated!

Carl

[Olly]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[HelpExcelForum]

Hi Olly,

I have tried to upload a file 82.5KB and get the following error message;

407 [IOErrorEvent type = "ioError" bubbles=false cancelable=false eventPhase=2 text="Error#2038"]

Any ideas?

Thank you

Carl

[JBeaucaire]

If you're using Internet Explorer, try turning on Compatibility View.
If that doesn't work, an alternate browser maybe?

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[MickG]

Try this:-

Please Login or Register  to view this content.

Regards Mick

[HelpExcelForum]

John H. Davis, MickG you guys are heroes! Thank you so much, i'm in awe!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.

[JBeaucaire]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.