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
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