Multiple search on excel

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

I found this brilliant post on how to search multiple entries simultaneously on excel and make a new sheet with the searched items.
http://www.computing.net/answers/of...

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.

Cheers!
Amit


See More: Multiple search on excel

Report •


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

Report •
Related Solutions


Ask Question