hello all,
The problem i am facing can be best illustrated using the following example
I have a list of industries - communications and electronics, and for indu01 i have two manufacturers: siemens and nokia; for electronics i have dell and acer.
then I have this search worksheet, which will work like this: in cell "A1", there is a drop down list of industries. if i select "communications", then in cell "B1" manufacturer drop-down list, only "siemens" and "nokia" will be up for clicking.
Now comes the part that bothers me. all of the industry and manufactures have to be dynamic or expandable. For example, the industry will include chip-making industry, chemical and so on. So will the manufacturer lists -- the communication industry manufacturer list will be added Ericsson, Samsung...the electronics one will add Samsung, LG, Toshiba...
I did a search on threads and found some useful old threads, such as
http://216.92.17.166/board2/viewtopic.php?t=60461&highlight=data+validation+category
where, however, all lists are fixed in range.
I tried to use offset() function to make lists expandable, but then indirect() function would not work.
Any suggestions?
Rgds
The problem i am facing can be best illustrated using the following example
I have a list of industries - communications and electronics, and for indu01 i have two manufacturers: siemens and nokia; for electronics i have dell and acer.
then I have this search worksheet, which will work like this: in cell "A1", there is a drop down list of industries. if i select "communications", then in cell "B1" manufacturer drop-down list, only "siemens" and "nokia" will be up for clicking.
Now comes the part that bothers me. all of the industry and manufactures have to be dynamic or expandable. For example, the industry will include chip-making industry, chemical and so on. So will the manufacturer lists -- the communication industry manufacturer list will be added Ericsson, Samsung...the electronics one will add Samsung, LG, Toshiba...
I did a search on threads and found some useful old threads, such as
http://216.92.17.166/board2/viewtopic.php?t=60461&highlight=data+validation+category
where, however, all lists are fixed in range.
I tried to use offset() function to make lists expandable, but then indirect() function would not work.
Any suggestions?
Rgds