B
BEEJAY
Greetings All:
(Excel 2003)
I'm trying to "clean up" various workbooks and consolidate into one workbook
(probably about 75 sheets, when done). I have come to the conclusion that,
for clarity of my formulas, I should have used range names.
I have the Name Manager, version 3.2 from Jan Karel, which hopefully will
prove to be more than a little useful.
My current problem relates to the use of validation, based on info
from two cells, (either/or), and requiring a result of 1 of 2 validation
lists.
I hope the following is clear.
Cell C3: Truck Cell D3 = 0 (not applicable) or 1 (applicable)
Cell C4: Trailer Cell D4 = is opposite of above.
ie: if D3 = 1, then D4 = 0 and vice-versa
Cell C5: Length Cell D5: Actual length, to be selected from 1 of 2
possible lists
If D3 = 1, then the drop down list to have specific list of lengths
possible for a Truck, as listed in Range Name "TruckLengths"
If D4 = 1, then the drop down list is to reflect the list of lengths possible
for trailers, as listed in Range Name "TrailerLengths"
I need the references in D3 and D4, for many formulas, so I hope I
don't have to change my layout - although I will, if neccessary.
The correct validation list is to prevent the salesman from ordering,
for example, a 48 foot Truck, etc............
I hope there is a solution to my situation.
Thanks in advance for any response (preferably a helpful one)
(Excel 2003)
I'm trying to "clean up" various workbooks and consolidate into one workbook
(probably about 75 sheets, when done). I have come to the conclusion that,
for clarity of my formulas, I should have used range names.
I have the Name Manager, version 3.2 from Jan Karel, which hopefully will
prove to be more than a little useful.
My current problem relates to the use of validation, based on info
from two cells, (either/or), and requiring a result of 1 of 2 validation
lists.
I hope the following is clear.
Cell C3: Truck Cell D3 = 0 (not applicable) or 1 (applicable)
Cell C4: Trailer Cell D4 = is opposite of above.
ie: if D3 = 1, then D4 = 0 and vice-versa
Cell C5: Length Cell D5: Actual length, to be selected from 1 of 2
possible lists
If D3 = 1, then the drop down list to have specific list of lengths
possible for a Truck, as listed in Range Name "TruckLengths"
If D4 = 1, then the drop down list is to reflect the list of lengths possible
for trailers, as listed in Range Name "TrailerLengths"
I need the references in D3 and D4, for many formulas, so I hope I
don't have to change my layout - although I will, if neccessary.
The correct validation list is to prevent the salesman from ordering,
for example, a 48 foot Truck, etc............
I hope there is a solution to my situation.
Thanks in advance for any response (preferably a helpful one)