Hi Ozgrid Friends,
i m on seeking help regarding a manual task which i am doing..
here my task is like....i have Folder, which contains many workbooks, each workbook contains a
sheet called START, here in this START sheet, i need to checkout the B column
for the specific Word/ Approximate match "Not Required:"
if this word comes in B column, including that ROW & below ROWS has to be deleted from that sheet.
the same has to be done for all the workbooks in that folder.
in the attached sample workbook i have highlighed the ROWS in yellow, which has to be deleted.
Requesting someone Expert to help me on this Task.sample book.xlsx