Quote:
Originally Posted by Claus Busch
Hi Tyler,
Am Mon, 8 Apr 2013 17:18:35 +0000 schrieb Tyler B:
Sheet 1
A1 = Drop Down of OS (AIX, LINUX, WINDOWS)
Sheet 2
A1 = Copy of the choice from Sheet 1 - A1 (=IF(LEN(TRIM('Sheet
1'!A1))0,TRIM('Sheet 1'!A1),"")
?? = If statement saying if AIX, then your drop down list is limited to
Sheet 3 - A1:A5
A2 = Shows the drop down list utilizing Sheet 3 - A1:A5
Sheet 3
A1:A5 (Text Values)
name the range Sheet3 A1:A5 "AIX"
Select Sheet2 A2 = Data = Data Validation = List = =Indirect(A1)
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|
Claus,
Thank you for the reply, this worked.
However I realized i messed up in my example so have had to re-write it below.
I can get the one to work, just trying to figure out how to do the many options that I need.
Sheet 1
A1 = Drop Down of OS (AIX, Linux, Windows)
Sheet 2
A1 = Copy of the choice from Sheet 1 - A1:
=IF(LEN(TRIM('Sheet1'!A1))0,TRIM('Sheet1'!A1),""
?? = If statement saying if blank, do nothing, if AIX (Linux or Windows), then have a drop down list that is limited to Sheet3 - B1:B5, C1:C5, or D1:D5 (Respectively)
B2 = Shows the drop down list utilizing Sheet 3 - B1:B5, C1:C5, or D1:D5
Sheet 3
A1:A5 (List of OS)
&
B1:B5 (LIst of AIX - AIX Small, AIX Medium, AIX Large)
C1:C5 (List of Linux - Linux Small, Linux Medium, Linux Large)
D1:D5 (LIst of Windows - Windows Small, Windows Medium, Windows Large)