Assign Macro to button that searches multiple excel docs and retrieves specific info

Hi All,

I think I may have approached this problem I have all wrong and need some assistance. I have used the attached code. I am searching for an ID in each excel document, in this case the ID is "DP". It does this fine but when I try to figure out how to get the value which is in the next cell I am stumped. I think I might need to start again. Assistance would be greatly appreciated. PS "DP" is in column G in every doc and the price or value I need as well is in the next cell column H

Please Login or Register  to view this content.

HI Davesexcel, thanks for replying and your suggestion. I wasn't clear in my first post. This code does work and searches the excel docs I have instructed it to and displays the information I have asked it to search for but I know need to ask it to also show the information in the next cell across from the information it has found. I was hoping to just add a bit of code but I think the apporoach has been wrong. Any thoughts? I have attached what the code search generates.

That's brilliant, thank's davesexcel. I did a quick tweak and it displays what I need. Thanks again.

Please Login or Register  to view this content.

Hi davesexcel I need to tweak this code a bit now. I need it to search only in a specific column in the multiple excel documents and then display the information from several columns from the same row, is that an easy tweak? EG Search for 'SM' in column A in all the excel documents and then when 'SM' is found display the information from select columns from that same row.

Hi Davesexcel, thanks again a couple more tweaks and Ive got it to do exactly what i want. Really appreciate the help.