• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA for Conditional Filtering

Status
Not open for further replies.

Vijayarc

Member
Hi Ninja Team
Please help on my below query
in my excel, when i click upload Dashboard button and i upload the dashboard file by browse then the data will copy in Batch_Report sheet
based on my code module for each sheets, the data will filter and delete columns and save on each sheets,
i have different filter condition for each sheets.

here i am facing issue is - on Daily_Pro sheet under columns M,N on TS and Credit header, i want to filter the condition as: 'NotStarted, Notstarted - 68 days' (all days should be grater then 7 days)
'Notstarted - 2 days' - should not filter, because it less than 7 days
Notstarted - 0 days' - should not filter, because it less than 7 days
Notstarted - 6 days' - should not filter, because it less than 7 days
Notstarted - 7 days' - should filter, because it equal to 7 days

in attached image, i coded wildcard search filter, but it filter all days.

please help and advise how to filter for above condition
i want the code should place on module 1- below the filter condition code as per image for my understanding, the same code i wan to respect for other sheets and columns
 

Attachments

  • Capture1.PNG
    Capture1.PNG
    61.6 KB · Views: 7
  • Chaser Mail Gene.XLSM
    108.6 KB · Views: 1
  • Dashboard.xlsx
    47.9 KB · Views: 1
  • Batch Report.PNG
    Batch Report.PNG
    193 KB · Views: 6
hi Ninja Team

Please help on my query, i am searching for more than 1 month for this macro
i ddit got any were for apt solution.
i am not technical strong to alter the code. so, kindly help on working macro code for my conditional filtering.
thanks in advance
 
Status
Not open for further replies.
Back
Top