Filter

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Joe <Joe@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 28 Jan 2009 10:23:01 -0800

Can I use the filter function in Excel 2007 to show headings and then when
one of the headings is selected it expands the list and shows each item
associated with the heading? For example:

Vehicle List A (Heading)
Car
Truck
Bus

Vehicle List B (Heading)
Car
Truck
Train

Vehicle List C (Heading)
Car
Motorcycle
Train

I want the filter to only show the headings (Vehicle List A, Vehicle List B,
Vehicle List C). However, what I want it to do is expand the table when I
select one of the headings. (Show the items under each heading.)

If the filter function isn't the way to go, I'm open to suggestions. Thanks.
.

Follow-Ups:
- RE: Filter
  - From: Shane Devenshire

Prev by Date: RE: Index return value REF#!
Next by Date: RE: nth occurrence of MATCH
Previous by thread: Index return value REF#!
Next by thread: RE: Filter
Index(es):
- Date
- Thread

Relevant Pages

Re: Error filtering for unique values
... The filter function see the first cell as a heading. ... Expand your range to: D9:D999. ... Just notice that it will copy the filtered range including the heading to the desired place. ...
(microsoft.public.excel.programming)
Re: Error filtering for unique values
... The filter function see the first cell as a heading. ... Expand your range to: D9:D999. ...
(microsoft.public.excel.programming)
RE: Filter
... Then when you only want to see the heading select it, ... "Joe" wrote: ... one of the headings is selected it expands the list and shows each item ... If the filter function isn't the way to go, ...
(microsoft.public.excel.worksheet.functions)
Re: Organizing literature in Excel
... Now fill in each of the rows with information appropriate to information name in column heading. ... Now open word and insert name of column heading ... when window open choose the desired excel file to get your information from. ...
(microsoft.public.mac.office.excel)
Re: Converting a Word doc to a multi-column Excel spreadsheet
... I'll post to microsoft.public.word.vba.general and explore Word VBA. ... into a multi-column Excel spreadsheet. ... I think that this processing would predetermine a format style, ... encountered content tagged with a Heading 1 format style, ...
(microsoft.public.scripting.vbscript)