VBA Excel; Stumped on formula to variable measurements to fixed measurements
Posted on 2016-10-20
I'm trying to create an Excel VBA formula as follows:
I have a count of bolts that are always the same length on a given run.
Individual runs may contain alternate lengths, but the lengths will be identical for each run.
Example: Run 1 = qty 520 bolts at 25" each
Example: Run 2 = Qty 100 bolts at 14" each
Example: Run 3 = Qty 100 bolts at 22" each
I have two variables:
I need a formula that will calculate how many pieces of 96" threaded rod that I need to purchase for each run.
So for example, on Run #1, I need to figure out how many pieces of 96" threaded rod I will need to obtain to cut all qty 500, 25" long bolts
And on Run #2, I need to figure out how many pieces of 96" threaded rod I will need to obtain to cut all qty 100, 14" long bolts
The formula only needs to work per individual run, it does not have to cover any other run.
Any help would be appreciated; I'm hoping that someone might have a default formula that they use for situations like this