View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Doug Broad Doug Broad is offline
external usenet poster
 
Posts: 3
Default something like autofilter?

In a spreadsheet that contains data for classes, some classes
have 2-3 rows of information, each row showing additional
meeting times.

Typical field names are
Dept, No, Sect, Course Title, Credit, Contact, Days, Times, Room, Instructor

Addtional rows for classes contain only information in Course Title, Days, Times, Room,
and Instructor
columns.

There are blank rows between classes.

Autofilter shows only the first row of each class. Does anyone have any ideas how to
show something like autofiltered data but allow the additional rows for each class to show
up
temporarily.

Thanks for your help.