I have created a workbook which processes entered data and measurements into
labour time and materials costs.

To simplify the process for my colleagues' use I wish to have items appear
only when necessary to reduce time spent reading the final data.

Eg. If A2 = Y then I want to display rows 3 and 4, if A2 does not = Y then I
want to hide rows 3 and 4 completely.

I have seen an example of this but have spent most of the day trying to find
it again unsuccessfully.

From this method I also hope to procure a means to automatically produce
quotations including these data AND prices AND some detailed methodology and
construction specifications.

Any help GREATLY appreciated!!