First time post.
I have been attempting to create code for a user form to show options of possible combinations of components to get to a user specified length.
I have components that come in 6 lengths (43,49,54,60,66) and I can use any combination or multiple of these lengths plus an single offcut length (0,3,5,8,11,16,19,25) to get within +/- 2 of the user specified length.
The user specified length can range from 43 through to 1000.
I have created tables of all possible combinations and have used lookup and match functions but I am thinking macro might reduce the size of this spreadsheet and enable further functionality such as choosing only 2 of the length variables to use instaed of looking at all 5.
Help on this code would be greatly appreciated.
Thanks
I have been attempting to create code for a user form to show options of possible combinations of components to get to a user specified length.
I have components that come in 6 lengths (43,49,54,60,66) and I can use any combination or multiple of these lengths plus an single offcut length (0,3,5,8,11,16,19,25) to get within +/- 2 of the user specified length.
The user specified length can range from 43 through to 1000.
I have created tables of all possible combinations and have used lookup and match functions but I am thinking macro might reduce the size of this spreadsheet and enable further functionality such as choosing only 2 of the length variables to use instaed of looking at all 5.
Help on this code would be greatly appreciated.
Thanks
