I'm not sure if I'm posting this in the correct spot or not and I don't know if my question has already been answered elsewhere since I have no idea how to sum it up! Basically, I have a chart of weights for various fasteners which is configured as X=Diameter, Y=Length with the weights listed in the chart. I want to import the weights into our software but it must be done as a complete formula. ie. M10X25 = 0.0125 lbs. each. Is there any way to take the excel data from the XY chart and put it into a usable format where it will display all lengths and diameters individually? I'm guessing this is VBA or maybe Access, but I don't know how to do it!
Bookmarks