Hi,

My name is Bertrand and I'm new on this forum. I've already found many interesting things on here but I'm still stucked with the following problem :

I've found a trick on this website (http://blog.contextures.com/archives...-pivot-tables/) in order to generate dynamic validation lists. It works perfectly but I wanna go a step further and it doesn't work. More concretely, this trick works very well for a "single-line-use". As far as I'm concerned, I wanna use such a trick to fill in a whole table (and thus on several lines).

Imagine 2 columns A and B. First of all, I want to select an item in a drop down list in column A. In function of the item chosen, a drop down list is automaticaly generated in column B. Both drop down lists are based on a pivot table (available in another sheet). The drop down list in B2 has to depend on the item chosen in A2, the drop down list in B3 has to depend on the item chosen in A3, etc... For the moment (refering to the trick given in the link), all the drop down lists in column B can only depend on 1 item (in A1 for example).

I naturally remain available to give more explanations if necessary.

Thanks in advance,

Bertrand