I have a requirement , where in in one excel sheet i have data with 5 columns (A, B , C , D , E)
now i want to search the excel on data with column A , where in i want to pass 20 strings at a time to search ,
if the record is found , then copy the entire row in another sheet and if the record is not found then copy that string in another sheet.
hey nishi i prepared a workbook.hope that will work for you
im new here.i dont know how to upload that file here.text me your email address or method to upload a file here whatever is convenient for u.if u find workbook helpful dont forget to thnx :)