Good morning/afternoon!
So I have a little problem. I have a large data set shown below:
And the following fields, where "Drilled Hole Volume" and ""Volume of Bolt" remain unchanged and static. The only field changing here is the "Volume of Cartridge". Basically I'd like some sort of VBA code or macro that can choose a maximum of two cartridges that when they populate the field "Volume of Cartridge", the field "Remaining Volume" gets as close as possible to 0. Once that is done, I'd like it to select those options in the ListBoxes. So, assume I selected 25 mm Dia x 12" and 28 mm Dia x 24", then it would look like the following:
Any help would be greatly appreciated. If needed, I can attach the Excel sheet! Thank you so much!
So I have a little problem. I have a large data set shown below:
And the following fields, where "Drilled Hole Volume" and ""Volume of Bolt" remain unchanged and static. The only field changing here is the "Volume of Cartridge". Basically I'd like some sort of VBA code or macro that can choose a maximum of two cartridges that when they populate the field "Volume of Cartridge", the field "Remaining Volume" gets as close as possible to 0. Once that is done, I'd like it to select those options in the ListBoxes. So, assume I selected 25 mm Dia x 12" and 28 mm Dia x 24", then it would look like the following:
Any help would be greatly appreciated. If needed, I can attach the Excel sheet! Thank you so much!
