Solved

# 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:

BoltQty

BoltLength

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

Thank you