Want to Create a Dynamic List Excel based on a few columns in another sheet .

[debsankardas]

Hi experts,

I have "sheet 1" which has two columns -1) Positions 2) Codes

In "sheet 2" I want to give some "Codes" input in Cell(B2) and based on value of the cell in B2 , the macro should be able to populate a list of all positions which matches the "Codes" from cells B4 downwards . Also when I change the "Code" value in B2 then the "positions" list below also changes based on data in "Sheet 1". ( dynamic List)


In Sheet 3 I want to do the same thing as in Sheet 2 but now in cell "B2" , I will input "Positions" and automatically list of "Codes will be populated below.


Thanks for your help.​