BurgoEng-
I tried writing one a while back but gave up when my company bought "Studs V4.1.1" from www.precastengineer.com. The program they have requires a hardware lock, but is relatively inexpensive and well worth the money. I tried submitting hand calculations to Engineers, but honestly I...
There is a very simple way to do this with a VBA function called "getTableValue()"....
Go to this website: http://www.bridgeart.net/spreadsheets/sprd_vba_functions.php
The owner of that site has written a very clever VBA function that will do exactly what you are looking for.
Good luck with your...
Yakpol... This is a wonderful spreadsheet!!! I have been looking for a something like this for a long time. I feel like I have finally found the the Holy Grail of beam analysis spreadsheets. What a wonderful piece of work. Thank you so much!!! Mark