Customize an Excel Function

Closed

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

Attached is an Excel spreadsheet (SERP [url removed, login to view]) - 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 ([url removed, login to view]). 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 [url removed, login to view] - I'd like this to be customizable to other Google engines (i.e.: [url removed, login to view], [url removed, login to view], etc.)

Please email me with any questions, suggestions or comments.

Thanks,

Daniel

Skills: Excel, PHP, Software Architecture, Visual Basic

See more: thanks you notes, seeking editor, php visual editor, me excel, google script editor, editor's notes, editor notes, dynamic ca, email script serp, php create function, google xls, google excel spreadsheet, Visual Basic Excel, serp, function, excel visual basic, excel function, excel based, daniel, create an excel, excel php dynamic, engine numerical, visual search engine php, google custom search engine, custom function php

Project ID: #817819

Awarded to:

justTry

Hi! I have sent you a message. Thank you. Regards, justTry

$50 USD in 0 days
(4 Reviews)
2.5

17 freelancers are bidding on average $94 for this job

hsameer

please check your PM

$70 USD in 1 day
(4 Reviews)
4.0
sameg

plz check PMB..

$100 USD in 3 days
(23 Reviews)
3.9
fcbarnard

Good evening I would like to be provided the opportunity to provide this service to you. PLease have a look at my profile and feedback. Please let me know should you have any questions.

$80 USD in 3 days
(8 Reviews)
3.8
dhs100

Hi, I understood what you wanted and have just finished writing it for you. It works a treat, across all the googles, etc. I'll PM you with the finished product so you can try it out. Cheers, Daniel

$100 USD in 0 days
(1 Review)
3.1
binaryromel

Lets start. Please check PM. Thanks.

$70 USD in 2 days
(3 Reviews)
2.0
unimaxtech

i can do this perfectly.. thnk u...

$50 USD in 3 days
(1 Review)
0.0
guessor

I have been using Excel to do a lot of calculations and implement lots of reporting fuctions for my customers.

$50 USD in 3 days
(0 Reviews)
0.0
amack

Over 10 years developing custom Microsoft Office automation solutions. Look forward to working with you on this project!

$70 USD in 2 days
(0 Reviews)
0.0
perissf

It's a simple project, I can complete it quickly

$180 USD in 1 day
(0 Reviews)
0.0
jitualam

plz give me for better work

$50 USD in 2 days
(0 Reviews)
0.0
kamalsk123

Sir, I have a good working experience for date entry. I present work done is date entry. I RESPONSIBILITES in this project. Ple, check my PM. Send me the details. Thanks.

$30 USD in 8 days
(0 Reviews)
0.0
ajaypradeep123

We have worked many excel macro's. Please give us your further happenings.

$75 USD in 6 days
(0 Reviews)
0.0
wahabkotwal

You can count on ME! Check out your PMB!

$200 USD in 15 days
(1 Review)
0.0
sunilkumartej

work can be done with speed & accuracy. I am available 24/7.have 20 years experience in data entry & accounting work.

$30 USD in 2 days
(0 Reviews)
0.0
anhsirk

Can provide you better solution.

$150 USD in 2 days
(0 Reviews)
0.0
lucipaun

blaaaaaaaaaaaa

$250 USD in 100 days
(0 Reviews)
0.0