Posts by ItsSugarBunny

Thankyouuuuu. It worksss! u make my life easier

Hello thanks for the reply. I already reupdate my question and attached the sample file above. Thankyou

So I want to extract data from a large data set using pivot. But i only want to extract specific data that contains specific word, can i do it with Pivot Table?
Let's say the large data set has 5column. i want to extract all the 5 columns, but only data contains word "SUP" and "C" in column A. Can i do it with PIVOT or is there other alternatives?

OMG THANKYOUU so muchh. It works perfectly! Xx

oh sorry about that im not sure what the terms for it. Do i need to make a new post for this case or just edit the title?

What do u mean by my userform remain totally empty?

i currently use this code formy userform:

Private isarrow As Boolean
Option Explicit
Dim myarray
Private Sub cmbCode_Change()




Dim i As Long, sh As Worksheet, st As Worksheet, lr As Long
    With Me.cmbCode
       If Not isarrow Then .List = myarray 'Range("code").Value
        If .ListIndex = -1 And Len(.Text) Then
            For i = .ListCount - 1 To 0 Step -1
                If InStr(1, .List(i), .Text, 1) = 0 Then .RemoveItem i
            Next i
            .DropDown
        End If
    End With
    
    
Set sh = ThisWorkbook.Sheets("sheet1")
Set st = ThisWorkbook.Sheets("sheet2")




lr = sh.Range("A" & Rows.Count).End(xlUp).Row




For i = 2 To lr


If sh.Cells(i, "A").Value = (Me.cmbCode) Or _
    sh.Cells(i, "A").Value = Val(Me.cmbCode) Then
    cmbName.Value = sh.Cells(i, "B").Value
End If


If cmbCode.Value = Sheets("sheet1").Cells(i, "A").Value Then
    txtStock.Value = st.Cells(i, "B").Value
   


End If


    


Me.cmbCode.SetFocus
Me.cmbCode.DropDown
Next


End Sub


Private Sub cmbCOde_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    isarrow = KeyCode = vbKeyUp Or KeyCode = vbKeyDown
    If KeyCode = vbKeyReturn Then Me.cmbCode.List = myarray 'Range("code").Value
End Sub






Private Sub UserForm_Initialize()
Dim db, mycollection As Collection, cell As Range




    With CreateObject("scripting.dictionary")
        For Each db In Range("code").Value
            If Not .exists(db) Then
                .Add db, db
            End If
        Next
        myarray = .keys
    End With


End Sub

Yes i need them both mutually dependant

already reupload. I promise this one is not empty
sorry and thankyouu!!

Oops sorry hehe i already reupload the file above. Hope it works Thanks!

Thanks a lot for ur help! Can you help me with this one, pleasee?

OMG THANKS!! It works like magic

Here i attach the file.thankyou

YES!! The test file is EXACTLY WHAT I EXPECT THANKYOU
I surely followed your explanation.

I have no idea what goes wrong but, what if i use column H & C instead of B & A? do i need to change the "k"value ?

i tried to apply the formula to my worksheet but it doesnt work, im trying to figure out what might goes wrong..

=INDEX(Sheet1!$B$1:$B$20;LARGE(IF(Sheet1!$A$2:$A$20=A2;IF(Sheet1!$B$2:$B$20>0;ROW(Sheet1!$A$2:$A$20)));1))

can i ask what is that for (the last number (1)) in the formula?

hello, can anybody help me, so i have two comboboxes in one userform and each of comboboxes are dependant. Currently, the first combobox (cmbCode) is typeable, has dropdown list and dependent with the stock box(txtstock) and name box (cmbname), but when i type in the second combobox (cmbName), second combobox is not typeable, has no dropdown list and not dependent with other boxes . I want to make second combobox is also typeable and dependent likewise the first combobox .Can you help me with the code? sampe file is attached below. Thankyou

Hello thankyou for reading my question. I already changed my question and attach the sample file. Hope i dont make u confused Thankyou

Hello, can anyone help me? so i've been trying to use VLOOKUP to return a value from a data table from another worksheet, BUT then VLOOKUP returns 0 and pick FIRST MATCH VALUE. I realized why it returns 0 because the source data table has zero/blank values and while VLOOKUP function only pick first match value, i guess (correct me if im wrong).So, what ive been confused about is, What function should i use to return LAST MATCH value from a data table from another worksheet ?

here i attach sampe file

i want to replace tht function. I have no idea what function am is supposed to use Any idea? Thanks in advance

Hello thanks for the help, sorry but what does this line mean "Following leaves a formula in the previous empty cells." ?

OMG sorryyy im such a noob Thankyou so muchhhh :')

sorry for the lack of information. let me illustrate:

. ........WS1................ . WS2
============ ============
.. A ......B ....C. . . .A ......B ........C
--------------------- ---------------------
1 x ....100........ 8 ..z.... 700 ....FALSE
2 y .....200. . ....9 ..r..... 600
3 z ......300... . 10 .x.... 100 ....TRUE

nb. 1-2-3-8-9-10 is a #cell

i wonder if its using vlookup formula?

here is i attached the sample workbook. thanks a lot