manipulating data in excel

See the attached document - it is only a sample and does not represent the whole data but I require a visual basic code that I can use as a macro in Excel to sort the data for me.

This is what i require:

In spreadsheet, you will see Sheet 1 and Sheet 2.

In Sheet 1, COL A, I have a bunch of URL addresses. In COL B, I have suburb data.

In Sheet 2, I have URL addresses in COL A and their meta data tags in COL B, C and D.

I need a script to do the following:

Using Sheet 1 as the primary Sheet, compare the URL addresses in Sheet 1 COL A with the URL Addresses in Sheet 2, COL A and then copy the exact match to COL C in Sheet 1. It should also copy the correct meta data columns from COL B, C, D from SHEET 2 and place in COL D, E, F in SHEET 1.

My budget is only $20. I know for a fact that this will not take long but cannot get access to my usual visual studio programmer today.

Only bid if you are prepared to do the work straight away.

Skills: Excel, Visual Basic

See more: visual studio programmer, primary data, need of excel programmer, i need a visual basic programmer, what is visual studio, what is macro in excel, visual studio excel, excel spreadsheet programmer, Visual Basic Excel, sort excel, meta data, excel work today, excel visual basic, Excel to Access, data in, compare spreadsheet, code columns excel access, excel macro sort, sort macro, excel macro match data

About the Employer:
( 16 reviews ) Sydney, Australia

Project ID: #5090601

Awarded to:


Well hi, this is really simple, i can do this in less then 1 hour. If you are interested please pm me, and i will do it for you. I don't take money unless you are 100% satisfied, btw i m really serious freelancer wi More

$20 AUD in 0 days
(4 Reviews)

2 freelancers are bidding on average $20 for this job


Hi, it will be done in 9 hours from now. I will code the macro that will do the match and copy the corresponding data to Sheet 1. Just a question, what do you mean by 'copy the exact match to COL C'? thanks

$20 AUD in 3 days
(32 Reviews)