Connect data from two tabs of a spead sheet
Places2000 (245 cities)
MSA DOL (270 metro areas)
Information from the MSA DOL tab will be added to the Places200 tab and a key (numerical field will be added to connect all the data at a later point in time. Same key for the same loation in both tabs)
Step 1 match Area_Name on the MSA DOL tab with Place Name on the Places2000 tab. Add the same number key (1, 2, 3///) in the key column of each tab. Make best matches possible. If unsure, type Yes in the blus "Check" column on the Places2000 tab and we will double check that item.
Step 2 copy the following field data from the MSA DOL tabs (yellow) to the matching city in the Places2000 tab (green). (AREA_NAME, TOT_EMP and JOBS_1000
I am professional in excel , Connect data from two tabs of a speadsheet
Relevant Skills and Experience
Excel
Proposed Milestones
$15 USD - Link data from two speadsheet
$15 USD in 1 day
5.0 (3 reviews)
1.0
1.0
6 freelancers are bidding on average $19 USD for this job
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Stay tuned, I'm still working on this proposal.
Hi,i can do this data entry task. I have seen the file. please send me a message for further discussion
Relevant Skills and Experience
https://www.freelancer.com/jobs/excel/
Proposed Milestones
$16 USD - milestones