Extract a dynamic list from a range in Excel based on specific criteria

[Raghav Chamadiya]

I want to extract serial numbers(Column A) from a range of data based on the value of column P (Release status). So, if the status is pending I want to add the serial number in my list.
In the end I want to show this dynamic list in a listbox in userform, where he will be able to further interact with it. Hence I want this done through VBA instead of formulae.
Thanks a lot

 

[NDMDRB]

Hi,

Through my search for a solution for my problem I found this post which is nearly the same as mine

I used your code with some changes as below, but I still have some changes that I didn't find a solution for

Dim Rng As Range
Dim Ary As Variant
Set wse = Sheet10
      Set Rng = wse.Range("F:F")

   Ary = Evaluate("transpose(if(" & Rng.Offset(, -1).Address(, , , 1) & "=""Wheel Loader""," & Rng.Address(, , , 1) & ",false))")

   Me.txtModel.List = Filter(Ary, False, False)

I have a database sheet with a lot of equipment and their details (Serial #, Type, Model, Make....)
In one of my UserForms, there is one ComboBox "txtType" which is a list using unique types only
Once I choose a Type, I need all the Models for this Type to be in the second ComboBox "txtModel"
Your code works fine, just one problem that is showing some Models several times

The needed changes are:

• Replace "Wheel Loader" with ComboBox "txtType"
• txtModel.List (I need it to get the unique values only if it's possible, since I need all the Models for the chosen type in ComboBox (txtType))
• Sort the list A to Z if possible also

Many thanks in advanced

 

[Fluff]

Please start a new thread for the question. Thanks.
Also please update your account details to show which version of Excel you are using, as it affects which functions you can use.

 

[NDMDRB]

Please start a new thread for the question. Thanks.
Also please update your account details to show which version of Excel you are using, as it affects which functions you can use.

Thanks Fluff,
Actually I post a thread few days before but didn't get what I need
Here is the thread link if you may help me with

Dynamic list based on Combobox value

Hi, I have a Workbook with many Sheets and a lot of lists using "Dynamic Named Ranges" Also a "User Form" with a lot of "Commands, Combo Boxes and Text Boxes" Here is a small sample of my Workbook EMV Master File - Test.xlsm If I need to add a new equipment, if the "Type" is already exist then...

www.mrexcel.com

 

[Fluff]

In that case I would suggest you refresh your memory regarding the board rules.
Especially Rule#12 about duplicate questions.

 

[NDMDRB]

In that case I would suggest you refresh your memory regarding the board rules.
Especially Rule#12 about duplicate questions.

But I didn't find similar questions that day once I post mine, anyway it's posted and can't return it back, so do you have a solution for my problem please