Display rows from multiple sheets matching a criteria
Hi, Can somebody pls help me.
I have multiple sheet in a workbook with same patients data of different years. I want compare their health records in a new sheet with use of search by identification number. I have code which works for single sheet , pls somebody help me how to extend it for multiple sheets. below is the code which works for EHC 14-15 sheet, I want the search to display the results from EHC 13-14 sheet also.
HTML Code:
Last edited by rudswa; 03-27-2015 at 06:13 AM.
I have attached the excel sheet . Pls somebody help.
Maybe:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
@xladept, Thanks a lot. It worked like charm.
You're welcome and thanks for the rep!
Hi,
Everything working fine, but I want hyperlink to the original sheet cell from the search results. Pls somebody help.
Last edited by rudswa; 04-14-2015 at 02:27 AM.
Any help pls
Hi,
Everything working fine, but I want hyperlink to the original sheet cell from the search results. Pls somebody help.
Hi Rudswa,
I don't understand what you want to recover, can you explain?
Hi xladept,Originally Posted by xladept
Thanks for reply. I need hyperlink on the search results, so that if I click on the hyperlink it will take to the original sheet & cell from where the value arises.
I have attached an excel. In that you can see that I have created hyperlink manually in the name field. I want that hyperlink generated automatically along with search results.
Sorry for my poor English, I am not able to put words properly.
MAybe:
Please Login or Register to view this content.
Last edited by xladept; 04-15-2015 at 04:57 PM.
Hi xladept,
Thanks for reply. it is creating hyperlink as i required but i am getting error "cannot open the specified file" when i click on hyperlink. Can you pls see.
Last edited by rudswa; 04-16-2015 at 12:30 AM.
Hyperlink address is directing to an unknown file
Capture.PNG
Hi Rudswa,
Nothing I've done has worked
But my research tells me that it may be because I'm using Excel 2010 - all I can say is: Try this
Please Login or Register to view this content.
Hi, xladept,
Thanks a million for this, I made very small changes and it worked like zoom. I'm on cloud nine. Thank you so much, you really saved my day.
HTML Code:
Wow! Excellent! AND NOW IT WORKS for my 2010!
Thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks