I found this brilliant post on how to search multiple entries simultaneously on excel and make a new sheet with the searched items.
The post here tackles exactly what I need: To search a list of genes (that I have in Column A, Sheet 3 of my workbook), match it to Column B sheet 1 and then finally have the output in Sheet 2.
However, I have multiple entries of one gene and this method is listing only the first entry it finds.
I searched more and found another post on this issue (http://www.computing.net/answers/office/excel-macro-only-finds-first-entry/15118.html) but somehow it is not working for me.
Can someone be kind enough and help with the complete code that I need to write for the Macros? It is my first post, so kindly correct me if I have made any mistakes and I will be happy to give more details to make it convenient to solve the issue.