Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Drop down lists that auto create and then filter the next drop down list

I'm trying to set up a spreadsheet using drop down menus

I currently have some 120 rows.

In the first column the are 4 possible choices of form (approx 30
records will have this value). However these values will change
regularly and I dont' want to keep looking to see what they are.

In the second column are names.

When I select the form I only want the second column to have the names
of people from that form.

I can do this using Autofilter if the records are on the same sheet
but I would have to hide a lot of rows and columns that I don't want
the user to see. I would like do the filtering on one worksheet, while
the data is held on another. On the first worksheet I would display a
range of graphs etc. based on the data found

Does that make sense?

Thanks

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,118
Default Drop down lists that auto create and then filter the next drop down list

See Debra Dalgleish's coverage of Dependent Lists:
http://www.contextures.com/xlDataVal02.html

Is that something you can work with?

Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

wrote in message
ps.com...
I'm trying to set up a spreadsheet using drop down menus

I currently have some 120 rows.

In the first column the are 4 possible choices of form (approx 30
records will have this value). However these values will change
regularly and I dont' want to keep looking to see what they are.

In the second column are names.

When I select the form I only want the second column to have the names
of people from that form.

I can do this using Autofilter if the records are on the same sheet
but I would have to hide a lot of rows and columns that I don't want
the user to see. I would like do the filtering on one worksheet, while
the data is held on another. On the first worksheet I would display a
range of graphs etc. based on the data found

Does that make sense?

Thanks



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Drop down lists that auto create and then filter the next drop down list

On 29 Sep, 19:49, "Ron Coderre"
wrote:
See Debra Dalgleish's coverage of Dependent Lists:http://www.contextures.com/xlDataVal02.html

Is that something you can work with?

Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

wrote in message

ps.com...

I'm trying to set up a spreadsheet using drop down menus


I currently have some 120 rows.


In the first column the are 4 possible choices of form (approx 30
records will have this value). However these values will change
regularly and I dont' want to keep looking to see what they are.


In the second column are names.


When I select the form I only want the second column to have the names
of people from that form.


I can do this using Autofilter if the records are on the same sheet
but I would have to hide a lot of rows and columns that I don't want
the user to see. I would like do the filtering on one worksheet, while
the data is held on another. On the first worksheet I would display a
range of graphs etc. based on the data found


Does that make sense?


Thanks



Thanks for that article 13 did the trick

Gary H

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
how do I use one drop-list to modify another drop-lists options? [email protected] Excel Discussion (Misc queries) 3 September 9th 07 05:46 PM
Drop Down list to run Auto filter on another sheet Mitch4 Excel Discussion (Misc queries) 2 July 23rd 07 03:40 PM
Using a drop-down list along with an auto-populate drop-down CrazyLostConfused Excel Discussion (Misc queries) 1 April 17th 07 12:10 AM
How do I create drop-down list boxes from multiple lists/headers HogLoRidr Excel Worksheet Functions 1 October 14th 06 04:04 AM
Can I create a drop-down list that will reference other drop-down fdebelo Excel Worksheet Functions 3 January 7th 06 10:34 AM


All times are GMT +1. The time now is 04:00 AM.

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

About Us

"It's about Microsoft Excel"