I have tried information from the site but did not help me 100% (http://www.contextures.com/xlDataVal02.html)
B2 is drop down lsit,
C2 is drop down list and should change based on B2. ( I could this )
D2 is also drop down list and should also change based on B2.....(I could do this too)
But did not quite work for below rows like B3, C3, D3----B4,C4,D4 and son on..
When I copied entire row-2 (to row 3) , C3, and D3 are referring to B2 instead B3
pleas see attache pic that explains with a example