Hi
I would like a macro to list items with quantity that can be put in a box from a total number that has been shipped. The attached spreadsheet shows a table containing items listing total quantity shipped against corresponding quantity per box. Each item has a maximum quantity per box which is defined in column B. The expected results are shown from D10 to E23.
Thanks.
Bookmarks