Hi Ninja
I want macro to filter column which is grater than 7 days ageing , trick part is
columns value will be like, mixed up
Completed - 14 Days
Completed - 0 Days
Rejected - 84 Days
Rejected - 103 Days
Completed - 0 Days
Rejected - 84 Days
WIP - 601 Days
NotStarted - 684 Days
NotStarted
NotStarted - 84 Days
I want to filter only WIP-601 days 'NotStarted', NotStarted - 684 Days
(all days grater than 7 days only)
please find my sample file in 'M , N 'column I need to filter
kindly help and do needful
I want macro to filter column which is grater than 7 days ageing , trick part is
columns value will be like, mixed up
Completed - 14 Days
Completed - 0 Days
Rejected - 84 Days
Rejected - 103 Days
Completed - 0 Days
Rejected - 84 Days
WIP - 601 Days
NotStarted - 684 Days
NotStarted
NotStarted - 84 Days
I want to filter only WIP-601 days 'NotStarted', NotStarted - 684 Days
(all days grater than 7 days only)
please find my sample file in 'M , N 'column I need to filter
kindly help and do needful