Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 14th 04, 07:55 PM
lorraine
 
Posts: n/a
Default limit cell list selection based on the selection of another list

I want to create a list in excel that will automatically limit the user's
selection based on their selction in a previous cell. I know some VBA and can
crete a macro if I need to. Your advice is appreciated.

  #2   Report Post  
Old December 14th 04, 08:14 PM
Frank Kabel
 
Posts: n/a
Default

Hi
try:
http://www.contextures.com/xlDataVal02.html

--
Regards
Frank Kabel
Frankfurt, Germany

lorraine wrote:
I want to create a list in excel that will automatically limit the
user's selection based on their selction in a previous cell. I know
some VBA and can crete a macro if I need to. Your advice is
appreciated.



  #3   Report Post  
Old December 14th 04, 08:17 PM
Jason Morin
 
Posts: n/a
Default

If your lists are generated with Validation, check out:

http://www.contextures.com/xlDataVal02.html

HTH
Jason
Atlanta, GA

-----Original Message-----
I want to create a list in excel that will automatically

limit the user's
selection based on their selction in a previous cell. I

know some VBA and can
crete a macro if I need to. Your advice is appreciated.
.



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
Extracting Values on one list and not another B Schwarz Excel Discussion (Misc queries) 4 January 7th 05 01:48 PM
Delete Cell Value Based on Another Cell T or F DocuMike Excel Discussion (Misc queries) 3 January 5th 05 08:46 PM
Selecting data from a list based on entered values GrantM Excel Discussion (Misc queries) 1 December 20th 04 10:59 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
Returning a Value to a Cell Based on a Range of Uncertain Size amc422 Excel Worksheet Functions 7 November 14th 04 03:03 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017