#1
|
|||
|
|||
Creating a spreadsheet
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!! |
#2
|
|||
|
|||
Hi,
please look at my solution on issue https://www.msofficeforums.com/excel...ate-lists.html Would this kind of technique help you (i.e. rows are shown or hidden depending on different conditions, but not filtered, instead shown on another sheet) Kind regards Bjorn |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cell Comments in a Protected spreadsheet | dmgerber | Excel | 1 | 06-06-2010 05:10 AM |
How do I use an Excel form to populate and Excel spreadsheet | apostht | Excel | 0 | 05-21-2006 11:17 AM |
Hyperlinking pdf file into spreadsheet | mygoat | Excel | 0 | 05-09-2006 11:59 PM |
Creating new project Using PDS | myanilkumar | Project | 0 | 01-05-2006 12:35 AM |
Spreadsheet for words | Rosie | Office | 3 | 06-15-2005 02:27 PM |