Hi,
Attached you will find the S&P industry table (from their website) in
raw form, that is the main industries according to GICS, and the main
subindustry division. Now what I need to create, is a data validation
list on sheet 2 that selects the industry (as in bold), and another
validation list that applies a data validation list based on the first
choice. In other words, if you would choose "Healthcare Supplies &
Services" in box one, you would only be able to choose among the
subindustries within that sector in box two.
I hope someone understands what I am trying to build here, I'm really
struggling.
Thanks,
Peter
+-------------------------------------------------------------------+
|Filename: excel question.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=4789 |
+-------------------------------------------------------------------+
--
Peter1999
------------------------------------------------------------------------
Peter1999's Profile:
http://www.excelforum.com/member.php...o&userid=33997
View this thread:
http://www.excelforum.com/showthread...hreadid=543649