447130 Customize an Excel Function

Avg Bid (USD)
Project Budget (USD)

Project Description:
I have attached an Excel visual basic script that has 95% of the functionality I am seeking.

Attached is an Excel spreadsheet (SERP Rankings.xls) - the script can be viewed in Excel's Visual Basic editor. If you open it you can see that it queries a specified website for a set of keywords and returns a numerical result based on the website's ranking for that keyword on Google.

What I would like is a modification of this script to create a custom function (i.e. =findrank) to work with the second attached spreadsheet (sample.xls). Column A is a URL and Column B is a Keyword. The function should take both of these inputs and return a numerical rank based on Google's search engine results.

So the custom function would be something like =findrank(URL,keyword) and would automatically return a dynamic result based on Google's search engine result listings. I am unable to code in Visual Basic but it appears from the functionality of the attached script that this should be very easy to modify.

Some notes:
-The attached script is defaulted to check Google's first 30 results. I'd like this to be customizable.
-The attached script is defaulted to check google.com - I'd like this to be customizable to other Google engines (i.e.: Google.ca, Google.co.uk, etc.)

Please email me with any questions, suggestions or comments.


Skills required:
Anything Goes, Excel, SEO, Visual Basic, Website Management
Hire danielrobinson
Project posted by:
danielrobinson Canada
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.