Hi Ninjas
->we have sheets which data update daily dynamically 1500 to 2000 rows
--> attached sample excel columns text be as - (NoRelationship - 3 Days , Rejected - 125 Days , Completed - 9 Days )
--> Requirement result samples are highlighted in green
1. find Word "Rejected" in 16 Red highlight columns and retrieve respective column headers - (attached file have sample 9 red column only)
3. find Ageing Bucket of each reject( by number in between string)
4. pivot on Ageing Bucket based on LOB Names
is it possible to automate this conditions
please help to automate the case, for large row numbers takes 3 hrs for this daily
->we have sheets which data update daily dynamically 1500 to 2000 rows
--> attached sample excel columns text be as - (NoRelationship - 3 Days , Rejected - 125 Days , Completed - 9 Days )
--> Requirement result samples are highlighted in green
1. find Word "Rejected" in 16 Red highlight columns and retrieve respective column headers - (attached file have sample 9 red column only)
3. find Ageing Bucket of each reject( by number in between string)
4. pivot on Ageing Bucket based on LOB Names
is it possible to automate this conditions
please help to automate the case, for large row numbers takes 3 hrs for this daily