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

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.​
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Watch MrExcel Video

Forum statistics

Threads
1,108,677
Messages
5,524,230
Members
409,566
Latest member
santoshsj

This Week's Hot Topics

Top