How do I display lines depnding on a cell critrera
 

How do I display lines depnding on a cell critrera
 

How do I display lines depnding on a cell critrera

Try Autofilter. DataFilterAutofilter

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
---

How do I display lines depnding on a cell critrera
 

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" wrote:

How do I display lines depnding on a cell critrera

Try Autofilter. DataFilterAutofilter

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
---

How do I display lines depnding on a cell critrera
 

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 DataFilterAutofilter 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
---
"Greg S" wrote:
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.