I uploaded the file (CPE2) to you. I help poeple build homes, by helping them be an "owner-builder, and save 15-25% on building their homes.
I am develoving a spreadsheet, that will allow them to ESTIMATE how much their home will be with out spending a dime.
I've been doing this for 40 years! Over 500 homes.
When they pick what they want in their home, by selecting the radio buttons, I want each sellection they make, add or subract from the formulated "cost" of the home.
Each sellection they make will be used in the formula, that is calculating, in the boxes on each page,the ESTIMATED cost of their home.
I want to know how each sellection can be used in my formula.
Opps, I did not see a 6-digit File ID. Should I do it again? And where should I look for this ID?
Yes. The "Custom Project Estimate" box will constantly upgrade and re-calculate when each radio button is selected.
The "cost per Sq. Ft." box will be calculated from the selection of the product of the "Custom Project Estimate" divided by the size of the home they have selected.
I trying to find out how I can use the "selection", in each catagory, to be used in the formula of "Custom Project Estimate'
Maybe in a macro?
"Custom Project Estimate", CPE Box, Would be empty if no radio boxes were selected.
The reason any of them, both the CPE box and the "cost per sq. ft." box have anything in them is for my prototype.
The CPE box will, hopefully not have a HUGE formula., But that's what I'm trying to discover.
Under "step !", if someone selected the radio "One Story - 900- 1,399 Sq. ft." I would want the "pre-selected by me number" , let's say $43.25 (Per sq. ft.) to be placed into the formula calculating the CPE.
Thank You ! What I have read, and it's 2:00 am here, God only knows what time it is where you are, I'm having problems with my internet, and will answer you tomorrow. So far EXCELLENT.
I will have many more questions... so what is a sure way to reach YOU?
I've been pouring over you response. It is very helpful but, a few questions have arose.
In your VLOOKUP formula VLLOKUP(Sheet2!B2,Sheet2!A4:AA18,2,FALSE)...when radio "4" is selected the product comes up 7 and when radio "5" is selected 4 comes up ???
Why in the range A4:AA18 did you use AA18 and not B18?
Thank You very much. Your help, both this time and the first, was very helpful. Thanks again for your help!
I went out and bought Excel 2010 Bible because your knowledge of the Excel program has inspired me to obtain a "small" fraction of what you have.