I have an excel sheet with 3 columns,
[Col 1] contains values like this A12345/111
I have my filter criteria stored in a data item which is "A12345"
Now i have to filter the column in excel which matches "A12345" so all the rows which matches the filter data item has to be stored into another worksheet and the rows which does not match has to stored into another sheet. How can i filter this column by taking the cell value till "/" which matches the filter data item?
I have tried getting the worksheet as collection and filterd it but the sheet has 1000's of rows so writing the collection into excel is taking alot of time and throwing my process into warning stage for a period of time.
[Col 1] contains values like this A12345/111
I have my filter criteria stored in a data item which is "A12345"
Now i have to filter the column in excel which matches "A12345" so all the rows which matches the filter data item has to be stored into another worksheet and the rows which does not match has to stored into another sheet. How can i filter this column by taking the cell value till "/" which matches the filter data item?
I have tried getting the worksheet as collection and filterd it but the sheet has 1000's of rows so writing the collection into excel is taking alot of time and throwing my process into warning stage for a period of time.