Results 1 to 11 of 11

Need a Clickable link to a website - URL changes

Threaded View

  1. #1
    Registered User
    Join Date
    08-10-2016
    Location
    Melbourne, Australia
    MS-Off Ver
    2013
    Posts
    6

    Talking Need a Clickable link to a website - URL changes

    Hello,
    I'm new here and glad to be part of this community.

    This is what I am trying to achieve. Any help would be hugely appreciated.

    I want to visually validate a number that has been entered into the spreadsheet (This number is an Australian Business Number)
    My plan is to enter the Australian Business Number into the spreadsheet, then simply click a button to load up the Australian Business Number lookup website.
    The website will show me if the ABN I entered is actually valid. I will simply look at the website, match the ABN with the customer's business name, then close the webpage.

    To do this, I have an idea, but I need some help.

    I have downloaded a certain picture. It is a picture of a magnifying glass. I would like this magnifying glass to be clickable.
    It will link the user to the ABN Lookup website, which will have the search string added.

    The link I made below works. But I want to somehow add that link to the magnifying glass picture somehow.
    I want the link to update the search text dependent on the Australian Business Number entered into the spreadsheet

    =HYPERLINK("http://abr.business.gov.au/SearchByAbn.aspx?SearchText="&R2)

    I would be so grateful for any assistance or guidance.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how to click any link in a website and extracting the new link and text in our excel sheet
    By prahladsingh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2016, 11:55 AM
  2. Entering a clickable Explorer File link....
    By yozzdi in forum Excel General
    Replies: 2
    Last Post: 10-16-2014, 07:12 PM
  3. Format cell to be a clickable link when workbook is opened on iphone
    By CW2013-work in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2013, 07:10 PM
  4. Clickable link to file in CDO Email body
    By cschoyer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2012, 02:11 PM
  5. [SOLVED] generate "clickable" link leading to a cell reference?
    By magicbob007 in forum Excel General
    Replies: 5
    Last Post: 11-22-2011, 03:37 PM
  6. Use Sheet Label as Clickable Link to
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 05-02-2011, 12:45 PM
  7. Putting a clickable link in the body of email sent from Excel
    By raehippychick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2008, 06:04 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1