Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-27-2009, 01:52 PM
nickypatterson nickypatterson is offline Creating a spreadsheet Windows XP Creating a spreadsheet Office 2003
Novice
Creating a spreadsheet
 
Join Date: Aug 2009
Posts: 2
nickypatterson is on a distinguished road
Default 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!!
Reply With Quote
  #2  
Old 01-14-2010, 03:21 PM
BjornS BjornS is offline Creating a spreadsheet Windows Vista Creating a spreadsheet Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

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
Reply With Quote
Reply

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
Creating a spreadsheet Spreadsheet for words Rosie Office 3 06-15-2005 02:27 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 09:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft