i have a folder with bulk files in it, Here my task is
STEP1: I need to open each & every file & check the sheet name called START, in this sheet E column cells contains text as PROCEED & also other texts,
i just need this entire row to be highlighted if the cell contains word PROCEED.
Then i need to go for B column in same sheet &
here B column contains the sheet names (sheetA,sheetB,sheet1....etc)
as per the sheet names in B column, the workbook also contains the sheets in the same names.
Now i need to keep the sheets, only which are highlighted in above STEP1, rest all sheets can be deleted.
Now the same process has to be repeated for the entire files in that folder.
for better understanding i have attached the sample workbooks & manually higlighted some ROWS
also changed the sheet name in RED, which are need & rest all to be deleted.
i know its a big ask, but i m requesting some experts to help me.
Thanks in Advance.not req.zip