Filtering data VBA

  • I have wrote a code to filter the data with multiple strings but its not working. I have attached a workbook as well your help will be appreciated.



    Files

    • Data.xlsm

      (20.1 kB, downloaded 38 times, last: )
  • Try:

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • thank you very much for the shorter solution.


    But if you test the below attached sheet to filter the data with your code. Why filter is start from Row8 rather than Row11.

    Files

    • Data.xlsm

      (20.59 kB, downloaded 37 times, last: )
  • The problem was caused by the merged cells containing the dates. You should avoid using merged cells because they almost always cause problems for macros. I have unmerged the cells. Try the attached file.

    Files

    • mithu.xlsm

      (21.47 kB, downloaded 36 times, last: )

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • You are very welcome. :)

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.