VBA: Index match multiple criteria & autofill until last row with Column as ref

  • Hello,


    It would seem from your private message ... that you do keep on modifying your worksheets' structures ...


    Please attach the very last version 5 to your next message ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hello,


    It would seem from your private message ... that you do keep on modifying your worksheets' structures ...


    Please attach the very last version 5 to your next message ...


    Hi Carim,


    Thanks for your response.


    Regret for inconvenience caused.


    I have uploaded V5 for your ready reference, requesting you to provide the solution.


    Thanks in advance again for your time & support.


    - Billy

  • Hello,


    Attached is your last TURBO version... which deserves the V6 attribute ... !!! :smile:


    Hope this will solve all issues


    Hi Carim,


    I am speechless to express my gratitude. Your code is magic working the way I wanted it for.


    Thanks a lot, I really owe you greatly.


    - Billy

  • Glad to hear you have finalized your project ...;)


    Thanks a lot ... for both your Thanks AND for the Like ...:)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hi Carim,

    Your code is working fine. I have modified it to suit my requirement. However, I want to run this code by clicking on the cell instead of the button. I'm trying to link this code to another VBA that runs after clicking on the cell.


    Edited once, last by Carim: Added Code Tags ().

  • Hello,


    Are you saying the macro you have modified is producing the results you are expecting ...?


    It seems to be the case ...


    So your question is how to run this macro from a double-click event macro ...


    Below is an example you will need to adapt to your specific situation ...


    Code
    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    ' Modify the Address of the Cell you want to use ...
    If Target.Address <> "$A$1" Then Exit Sub
    Application.Run ("Results")
    Cancel = True
    End Sub


    Do not forget an Event macro is to be stored in the worksheet module ...;)


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • OK ...


    The Forum rules are calling for you to create your own thread ... a brand new thread ...


    When creating your thread ... please remember two things :


    1. Attach a sample file


    and if you want to post a macro ...


    2. Use Code Tags </>


    Will delete your Message # 28 ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hello Carim ,

    I have attached file for your reference.

  • As already indicated ... you do need to create a NEW THREAD ...


    Below is an Image of the Main Menu ... with the Button + CREATE THREAD



    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!