Home |
Search |
Today's Posts |
#1
|
|||
|
|||
can i use excel to generate web links
Hi,
I work for a charity - we're going through our donors at the moment and have to search for each one individually in the charity commision website. I was wondering if there's a way of using excel, which already has our data in, to generate urls linking to the above site's (or any) search engine incorporating the contents of a cell. ie: i'm searching for dog the search page url is www.search.com/search=?? and want to genenerate www.search.com/search=dog I want to generate one of each of these for each donor any thoughts would be greatly appreciated thanks simon |
#2
|
|||
|
|||
Maybe you could use an adjacent cell and a formula like:
=hyperlink("http://www.search.com/search=" & a1, "Click me!") (if Dog was in A1) simonrowland wrote: Hi, I work for a charity - we're going through our donors at the moment and have to search for each one individually in the charity commision website. I was wondering if there's a way of using excel, which already has our data in, to generate urls linking to the above site's (or any) search engine incorporating the contents of a cell. ie: i'm searching for dog the search page url is www.search.com/search=?? and want to genenerate www.search.com/search=dog I want to generate one of each of these for each donor any thoughts would be greatly appreciated thanks simon -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Add-in: Access Links | Excel Discussion (Misc queries) | |||
Want Excel to break links between worksheets in same file | Excel Worksheet Functions | |||
How do I remove external links from Excel 2000 workbook? | Excel Discussion (Misc queries) | |||
How do you set up a data excel sheet that links to a presentation. | Excel Worksheet Functions | |||
How do I Break links Using Excel 2000 | Excel Discussion (Misc queries) |