I don't need to see the spreadsheet or formulas. I am just looking for an explanation, in plain English, of your first couple of conditions, like you did in your original example:
So, you gave me two there. Can you give me a few more?
sure:
ideally, I'd like to have a front page where I can enter details about the project.
On this worksheet (lets call it Details) I would like to have a list of 15 measures that could be included for the project. Each one would have a yes/no option on a drop down list.
All of the pricing information for the measures would be on a separate worksheet (Pricing).
On the Details sheet, If you select yes, the relevant rows on the Pricing sheet would remain visible.
If you select no, the relevant rows would be hidden.
At the moment the way I have set it up is as follows:
Details sheet cell B21 - relevant cells to hide/unhide = Pricing sheet rows 8:15
Details sheet cell B22 - relevant cells to hide/unhide = Pricing sheet rows 16:33
Details sheet cell B23 - relevant cells to hide/unhide = Pricing sheet rows 34:48
Details sheet cell B24 - relevant cells to hide/unhide = Pricing sheet rows 49:61
Details sheet cell B25 - relevant cells to hide/unhide = Pricing sheet rows 62:75
Details sheet cell B26 - relevant cells to hide/unhide = Pricing sheet rows 76:98
Details sheet cell B27 - relevant cells to hide/unhide = Pricing sheet rows 99:120
Details sheet cell B28 - relevant cells to hide/unhide = Pricing sheet rows 121:126
Details sheet cell B29 - relevant cells to hide/unhide = Pricing sheet rows 127:139
Details sheet cell B30 - relevant cells to hide/unhide = Pricing sheet rows 140:147
Details sheet cell B31 - relevant cells to hide/unhide = Pricing sheet rows 148:154
Details sheet cell B32 - relevant cells to hide/unhide = Pricing sheet rows 155:160
Details sheet cell B33 - relevant cells to hide/unhide = Pricing sheet rows 161:166
Also, on the Details sheet, I would like to have a cell where you can enter the number of different house types the project has. When you enter the number, this would then show that amount of the relevant columns on the Pricing sheet.
The cell that you enter the number of types is on Details H2
The columns that would be hidden/unhidden would be as follows:
1 type - Pricing sheet, hide columns K:S
2 types - Pricing sheet, hide columns L:S
3 types - Pricing sheet, hide columns M:S
4 types - Pricing sheet, hide columns N:S
5 types - Pricing sheet, hide columns O:S
6 types - Pricing sheet, hide columns P:S
7 types - Pricing sheet, hide columns Q:S
8 types - Pricing sheet, hide columns R:S
9 types - Pricing sheet, hide columns S
Hope that makes sense