Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 08-27-2009, 01:52 PM
nickypatterson nickypatterson is offline Creating a spreadsheet Windows XP Creating a spreadsheet Office 2003
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
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

please look at my solution on issue

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

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

All times are GMT -7. The time now is 06:11 AM.

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