Em Andamento

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.

Habilidades: Excel, Visual Basic

Ver mais: 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, data compare, sample visual basic excel, sheet excel visual basic, 2013 excel visual basic, compare columns excel access

Acerca do Empregador:
( 16 comentários ) Sydney, Australia

ID do Projeto: #5090601

Premiar a:

MimiFL

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 Mais

$20 AUD em 0 dias
(4 Avaliações)
3.5

2 freelancers estão ofertando em média $20 para este trabalho

bouslimi1979

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 dias
(32 Comentários)
5.2