Multiple issues - Multiple IF staements with multiple answers, or other coding.

*If someone has a better title please let me know so I can edit and help others*

I'd like to start by saying thanks to everyone on these forums, over the last 2-3 years if I've had a problem I've been able to find the answer here or a 'new' way of tackling a task. My boss just knows the basics of Word/Excel/Outlook. and has asked me to build something to save him time with our Bid Proposals instead of him having to type it up every time. I thought it would be simple but just cant get it to look/work properly. For the first time I can seem to find the information I need by searching these forums.

What I am trying to do:

Ive created several tabs in excel, each with a list of descriptions and check boxes. The last tab is our Bid Proposal form (basically blank after our header).My idea was that my boss would be able to check the boxes that apply to each individual project, then the description would appear on the last Tab. He would then just need to print off the last page and fax it off.


My problem:

1st problem - Well on the last Tab I created a simple =IF('Tab1'!B3=True,'Tab1'!B4) In B4 I wrote the description "drywall on both side of wood framed wall" . Needless to say this didnt work like I planed so I changed it to =IF('Tab1'!B3=True,"drywall on both side of wood framed wall") this worked but just requires a little more typing than I wanted it do. If someone knows a shorter way that would be great.

2nd Problem - As stated above on the last tab I created each of these "If" statement in Cells A8 - A80 (for example). If he only checks 8 or 9 items from the other Tabs I have a lot of blank space. This is my biggest problem. Id like something that "If" Cell A10 ( for example) is blank the next one moves up, or something. I also though about merging A8-A80 (for example) together but Cant figure out a way to put all the "If" statement together to display all the description. I'm thinking this may take some special coding, That is beyond my knowledge. Is there a simple way I can go about doing this?

I've attached a copy of what I've been doing so far so everyone can have a netter understanding of what I'm talking about if my explanations were unclear.

well this works
=IF('Wall Types'!B3=TRUE, 'Wall Types'!C3,"")
but try this instead

Hi inzanesrt4 and welcome to the forum

before i even begin to try and adress your questions...
PLZ PLZ PLZ...try and avoid the use of merged cells, all the do is create havoc later when trying to reference then in a formula, and the same result can be achieved by using "center across selection" under cell formatting.

also, although using those check-boxes looks impressive, the way you are doing that, you might as well do away with them and just enter X (or whatever) into the cell and bace the references on sheet1 on that

1st problem
=IF('Tab1'!B3=True,'Tab1'!B4) doesnt work because you are referencing the row below the control, not the column next to it. try this...
=IF('Wall Types'!B3=TRUE, 'Wall Types'!C3,"") - note an if statement consists of 3 parts...
=if(criteria-to-test,what-to-do-if-test=TRUE,what-to-do-if-test=FALSE)

2nd problem
actually you only have that formula in A17:A19


I have modified your worksheets somewhat, take a look at the attached and see if that is something you can work with? (I eliminated the use of the check-boxes)

Happy to help. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)