I have a cost estimate sheet that will require estimators to enter in a measurement that will need to multiplied to figure out the square foot value. I would like something in VBA that would target 2 particular cells so that if the estimators want they can make the entry in a particular cell and it would convert it from any of 3 formats. The answer should always be expressed in footage which could be the multiplied to square footage (see spreadsheet).
4' 5-1/2" =4.458 (ft)
30" = 2.5 (ft)
30 3/4" = 2.5625 (ft)
Not all of the estimators have this issue of not being able to convert this in their head so i set up a sheet that will allow them to use this if they need to or not. I tried to be very specific on my sheet but feel free to ask any questions you have.