How to do a google search of data from multiple cells

[pickless]

I am creating a tool inventory sheet and would like to have a link, button, etc. to do a Google search of the combined cells (B2, D2, E2). Where i can select any single row, and it would perform the search.
Example: the function would open google and search Craftsman 47517 7/8". Then be able to research that tool.

I hope that makes sense. I actually was able to record a macro earlier, which did it. However, I cant seem to duplicate macro now, and I couldn't figure out how to get it to run from any row I select. Then I removed that macro in the process. Help, please!

Thanks in advance

 

[Anka]

Hello
I'm a beginner in this kind of stuff, but some time ago I did something similar for myself.
In a separate column you have to concatenate the necessary cells to create the search term. In your case

=CONCATENATE(B2&" "& D2&" "& E2 )

Pull the formula down for the rows you need.
Select the desired cell and run the code.

Sub test()
Dim IE As Object
Dim rngMyRange As Range
Dim cell As Range

Set rngMyRange = Selection

For Each cell In rngMyRange.Cells
    Set IE = CreateObject("InternetExplorer.Application")
    IE.navigate ("http://www.google.com/search?q=" & cell)
    IE.Visible = True
Next cell
End Sub

If you select multiple cells, multiple web browsers will open simultaneously, one for each selected cell.
Works for whatever you select in the sheet.
PS: Sorry for my English ...