How do I display lines depnding on a cell critrera

[Max]

Re: How do I display lines depnding on a cell critrera

Try Autofilter. Data>Filter>Autofilter

Imp: Do not leave your message area blank. Ever. Always use it to re-explain
& elaborate on your query. The subject line's just that, its not meant to be
the entire posting. Do note that responders using the same MS webpage (as
you) to read/respond will NOT be able to respond to any post with blank
message area (it's a technical glitch). So inadvertently, you're shutting
them out from helping you.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000, Files:362, Subscribers:62
xdemechanik
---

 

[Greg S]

HI Max

Sorry for the lack of infoamtion, this is the first time I am using this
service. Let me explain...

I have two options to select from and only one of the options can be
selected, lets call it A1 and A2.

If a person selects A1, I would like to view only lines 10 - 20, however if
a person selects A2, I would like to view only lines 20 - 40.

Greg

 

[Max]

Autofilter can give you the functionality you seek

Assuming your table is in cols A to C,
headers in row1, data from row2 down

Use an adjacent helper col D
Enter a label into D1, eg: Option
Enter a marker in D2, eg: x
Copy D2 down by 20 rows to D21
Enter the next marker in D22, say: z
Copy D22 down by 20 rows to D41

Then just select col D, click Data>Filter>Autofilter to apply it. From the
dropdown in D1, you would then be able to make the selection: x or z, which
would filter out the required lines, giving you the functionality that you
seek
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik