rakeshghuge
New Member
- Joined
- May 7, 2009
- Messages
- 9
HI....
I want to create a dynamic data validation sheet...
for insitance suppose i have a following database in excel...
Aggregate Sub-Aggregate Grade
Plastic PP Injection
Plastic PP Extrusion
Plastic pc Q10
Plastic pc QVT
Plastic pc Q80
Steel Steel Wire NA
Steel Steel Rod NE21
Steel Steel Rod NE40
Steel Steel Spring NA
now i have a huge list of Raw material in the database...
i want to create a series of datavalidation such that....if i select plastic in the first datavalidation then in the next data validation will only show a dropdown of the item which are infront of plastic in the above table....
like in this example...the first dropdown should show plastic & steel.....if i have selected plastic...the next dropdown list should show pp, pc...and if i select pc...the next dropdown should show Q10, QVT & Q80....
I want to create a dynamic data validation sheet...
for insitance suppose i have a following database in excel...
Aggregate Sub-Aggregate Grade
Plastic PP Injection
Plastic PP Extrusion
Plastic pc Q10
Plastic pc QVT
Plastic pc Q80
Steel Steel Wire NA
Steel Steel Rod NE21
Steel Steel Rod NE40
Steel Steel Spring NA
now i have a huge list of Raw material in the database...
i want to create a series of datavalidation such that....if i select plastic in the first datavalidation then in the next data validation will only show a dropdown of the item which are infront of plastic in the above table....
like in this example...the first dropdown should show plastic & steel.....if i have selected plastic...the next dropdown list should show pp, pc...and if i select pc...the next dropdown should show Q10, QVT & Q80....