Hello! I have a "Ship" button with a macro that copies filled out rows in an order form and adds them to a list of shipments in another workbook.
In Workbook A, there is a table of part numbers and their quantities, referred to in the code as iRow. Sometimes I have to make partial shipments, so I will fill out the order form to have a quantity of "0" on the part numbers that will not be shipped in that particular order.
I would like to create a macro that senses if there is a quantity of 0, that specific iRow does not get transferred to the shipments list.
The shipments list is referred to as kRow in the macro. Below you can see the code, and attached is the test workbook for additional reference.
Any help would be greatly appreciated![]()
Please Login or Register to view this content.
![]()
Bookmarks