I have succeeded with my scripts to get this calculating. However, I have a problem.
In this table, the # of Databases is set to multiply times the drop down box and enter into the final column, the # of GAPS does the same. The problem is if I change my mind and change the #, it will increase the final total by the amount chosen in the dropdown. How do I get it to stop?
I may not be able to help you directly but I think others will be able to assist if you post your code so they can troubleshoot where your syntax might need to be altered.