Multiple search on excel

June 14, 2012 at 05:36:57
Specs: Windows XP

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 ( 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.


See More: Multiple search on excel

June 15, 2012 at 00:29:16
No one there with an answer?? :(

Report •
Related Solutions

Ask Question