debsankardas
New Member
- Joined
- Apr 11, 2013
- Messages
- 1
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.
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.