I have a VBA program which applies a loop in a range for eg B1:B60 and then checks for Y and N in a Column and values of another column having that Y is displayed in a listbox.
Now what i require is that rather than loop applying for a range it should check for a value so that automatic updation can occur.
This means suppose B column has values in the form of One Two or Three so if add row with One in B Column then automatically programs adjusts it.
Welcome to the forum
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
Doing this will ensure you get the result you need!
i have attached a dummy
Making two combo boxes displaying "class" and then selecting "Good Cs" "Goodb" "Attentive". Displaying the names satisfying the criteria. Meaning if i select class - One and then Attentive, display all names satisying that criteria.
If i want to add another new entry, it should automatically adjusts itself in the program and i don not have to change the code for that.
Hi m_k
Can you add a before and after sheet in the workbook
I'm a little lost with what you need
Just to tell you series of steps to make it clear
1.Two combo boxes with first one having values of classes that is "One", "Two" and "Three".
the second one having values - "GoodCs", Goodb" and "Attentive".
2.Now suppose i select "One" from the first combobox and "Attentive" from the second combo box, it should display the corresponding names from column A having there classes as "One" and Y in the "Attentive" column. Listbox might display the result.
3.Now if i add another row of data then listbox should print the names checking the newly added row as well.
Hi m_k
I think this is it
a two value matrix lookup with multiple values
=IF(ISERROR(INDEX($A$1:$C$100,SMALL(IF(($B$1:$B$100=$G$1)*(OFFSET(B$1:B$100,0,MATCH(H$1,C$1:E$1,0))="Y"),ROW($B$1:$B$100)),ROW(G1:I1)),1)),"",INDEX($A$1:$C$100,SMALL(IF(($B$1:$B$100=$G$1)*(OFFSET(B$1:B$100,0,MATCH(H$1,C$1:E$1,0))="Y"),ROW($B$1:$B$100)),ROW(G1:I1)),1))
Thanx for this method, it works but can you work around by using Excel VBA that might be great.
hi m_k
Why VBA? its only for if it cant be done with worksheet function
Yes, but it would be great if u help in this with VBA.
OK vba it is
Try this example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
m_k 
Register To Reply
Bookmarks