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.