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.
Bookmarks