I want to read an Excel row and if the last 4 digits equals of all the values present in the column of the row matches the condition then i want those all the rows to be written into separate excel sheet.
Please help asap.
For example,there is an Excel sheet with
So i want to pick up only those rows whose last ends with “GLG=1” and writes it into separate excel sheet.
@harinathreddy.yn please suggest on this as well