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.
2 freelancers estão ofertando em média $20 para este trabalho
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