Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Validation List

Status
Not open for further replies.
Robert1688

Robert1688

Agricultural
Joined
Jan 13, 2007
Messages
14
Location
CN
Can a validation list in a cell is controled by another cell?
For example: if in cell "A1" is "Fruit", then the validation list in cell "B1" will be "Apple", "Pear", "Orange"; if in cell "A1" is "Furniture", the the calidation list in cell "B1" will be changed to "Table", "Chair", "Sofa".
I believe that will do a lot help to some people.
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

vinodnx7
  • Locked
  • Question Question
count the same text from the file and create new list with number
Replies
19
Views
2K
vinodnx7
vinodnx7
iken
  • Locked
  • Question Question
Data Validation Lists Using Dynamic Name Range
Replies
6
Views
604
SkipVought
SkipVought
kyleShropshire
  • Locked
  • Question Question
Spreadsheet bill of materials and separate parts lists
Replies
4
Views
540
3DDave
3DDave
jmarkus
  • Locked
  • Question Question
MS Excel - Drop Down Lists that result in links to original list cells
2
Replies
33
Views
1K
SkipVought
SkipVought
Blazerdog
  • Locked
  • Question Question
List lookup
Replies
3
Views
247
Blazerdog
Blazerdog

Part and Inventory Search

Sponsor

Back
Top