Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 26th 04, 11:19 AM
Patricia Martinez
 
Posts: n/a
Default Filtering Data with a Drop Down field

I have a table that kind of looks like this:

Auto Dinner IE Welcome Ball
Corp Annual Rpt
Name Company Title
P.M. Ford President X
X
J.M. Microsoft CEO X X
X
K.M. Microsoft CFO X
X

The first three letter of the "event" signal the industry we are targeting,
so Auto will be for Automotive, Corp for Corporate, IE for Industrial
Equipment, etc. I need to set up a drop down field that will filter by
Industry, for example if I only want to only see the "events" for Automotive
my table will reduce to this:

Auto Dinner Corp Annual
Rpt
Name Company Title
P.M. Ford President X X
J.M. Microsoft CEO X X

K.M. Microsoft CFO X


The ones marked Corp should always display but the one starting with IE will
dissapear. Something similar will happen if I select IE then Auto Dinner
will hide, etc.

Is there a way to do this?

  #2   Report Post  
Old November 28th 04, 01:12 AM
Steve Smallman
 
Posts: n/a
Default

Patricia,

On the data menu is an entry called Filter, under that is an entry called
auto filter.

This turns on the drop down filter arrows to filter a list in place and on
the fly.

I think this is what you are after.

Steve
"Patricia Martinez" wrote in
message ...
I have a table that kind of looks like this:

Auto Dinner IE Welcome Ball
Corp Annual Rpt
Name Company Title
P.M. Ford President X
X
J.M. Microsoft CEO X X
X
K.M. Microsoft CFO X
X

The first three letter of the "event" signal the industry we are
targeting,
so Auto will be for Automotive, Corp for Corporate, IE for Industrial
Equipment, etc. I need to set up a drop down field that will filter by
Industry, for example if I only want to only see the "events" for
Automotive
my table will reduce to this:

Auto Dinner Corp Annual
Rpt
Name Company Title
P.M. Ford President X X
J.M. Microsoft CEO X X

K.M. Microsoft CFO X


The ones marked Corp should always display but the one starting with IE
will
dissapear. Something similar will happen if I select IE then Auto Dinner
will hide, etc.

Is there a way to do this?



  #3   Report Post  
Old November 28th 04, 01:23 AM
Patricia Martinez
 
Posts: n/a
Default

Yes, I know abou that. The problem is that it filters rows and not columns.
Is there a way to hide columns?

"Steve Smallman" wrote:

Patricia,

On the data menu is an entry called Filter, under that is an entry called
auto filter.

This turns on the drop down filter arrows to filter a list in place and on
the fly.

I think this is what you are after.

Steve
"Patricia Martinez" wrote in
message ...
I have a table that kind of looks like this:

Auto Dinner IE Welcome Ball
Corp Annual Rpt
Name Company Title
P.M. Ford President X
X
J.M. Microsoft CEO X X
X
K.M. Microsoft CFO X
X

The first three letter of the "event" signal the industry we are
targeting,
so Auto will be for Automotive, Corp for Corporate, IE for Industrial
Equipment, etc. I need to set up a drop down field that will filter by
Industry, for example if I only want to only see the "events" for
Automotive
my table will reduce to this:

Auto Dinner Corp Annual
Rpt
Name Company Title
P.M. Ford President X X
J.M. Microsoft CEO X X

K.M. Microsoft CFO X


The ones marked Corp should always display but the one starting with IE
will
dissapear. Something similar will happen if I select IE then Auto Dinner
will hide, etc.

Is there a way to do this?




  #4   Report Post  
Old November 28th 04, 02:00 AM
Steve Smallman
 
Posts: n/a
Default

Patricia

sorry, to the best of my knowledge the filtering is based on criteria
columns and data rows, so in short, no column hiding.

unless you use VBA,

say a combo box to select, a change event for the combobox to hide the
columns not required

another option you might wish to explore is using a pivot table to summarise
the data, it gets awfully messy , but may achieve your goal. you could add
the columns containing event type to the page area, company, position and
name to the row area and add name to the data area, using the count
function.


Steve
"Patricia Martinez" wrote in
message ...
Yes, I know abou that. The problem is that it filters rows and not
columns.
Is there a way to hide columns?

"Steve Smallman" wrote:

Patricia,

On the data menu is an entry called Filter, under that is an entry called
auto filter.

This turns on the drop down filter arrows to filter a list in place and
on
the fly.

I think this is what you are after.

Steve
"Patricia Martinez" wrote in
message ...
I have a table that kind of looks like this:

Auto Dinner IE Welcome
Ball
Corp Annual Rpt
Name Company Title
P.M. Ford President X
X
J.M. Microsoft CEO X X
X
K.M. Microsoft CFO X
X

The first three letter of the "event" signal the industry we are
targeting,
so Auto will be for Automotive, Corp for Corporate, IE for Industrial
Equipment, etc. I need to set up a drop down field that will filter by
Industry, for example if I only want to only see the "events" for
Automotive
my table will reduce to this:

Auto Dinner Corp
Annual
Rpt
Name Company Title
P.M. Ford President X X
J.M. Microsoft CEO X X

K.M. Microsoft CFO X


The ones marked Corp should always display but the one starting with IE
will
dissapear. Something similar will happen if I select IE then Auto
Dinner
will hide, etc.

Is there a way to do this?








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Tables filtering data Excel GuRu Excel Discussion (Misc queries) 1 November 24th 05 08:41 PM
Pivot Table Customize functions in the Data Field PSKelligan Excel Discussion (Misc queries) 2 January 4th 05 06:51 PM
Charting data ranges that change mikelee101 Charts and Charting in Excel 2 December 16th 04 11:07 PM
Word field codes in Excel data file Includetext mranz Excel Discussion (Misc queries) 1 December 7th 04 11:19 PM
Method to increment value in data field? Karl H Excel Discussion (Misc queries) 1 December 4th 04 05:25 PM


All times are GMT +1. The time now is 07:10 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017