ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How would you go about... (https://www.excelbanter.com/excel-discussion-misc-queries/176440-how-would-you-go-about.html)

Cerberus

How would you go about...
 
This may be very basic but, is there a way to first of all limit the possible
true values if you have two drop downs. Say one drop down is of twenty
trailer lengths and the other is of seven suspension types, I want a way to
say that the first seven trailer lengths can only have two types of
suspensions and so on. Can this be done and if so how would you go about
this.

T. Valko

How would you go about...
 
See if this helps:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"Cerberus" wrote in message
...
This may be very basic but, is there a way to first of all limit the
possible
true values if you have two drop downs. Say one drop down is of twenty
trailer lengths and the other is of seven suspension types, I want a way
to
say that the first seven trailer lengths can only have two types of
suspensions and so on. Can this be done and if so how would you go about
this.




Cerberus

How would you go about...
 
Thank you for your help.

"T. Valko" wrote:

See if this helps:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"Cerberus" wrote in message
...
This may be very basic but, is there a way to first of all limit the
possible
true values if you have two drop downs. Say one drop down is of twenty
trailer lengths and the other is of seven suspension types, I want a way
to
say that the first seven trailer lengths can only have two types of
suspensions and so on. Can this be done and if so how would you go about
this.






All times are GMT +1. The time now is 09:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com