Closed

Excel Merge Project

I am using Office 360 (Excel) and I have a csv file with the following headers (and corresponding data):

First Name,Last Name,Address,City,State,ZIP,Phone,Home Owner,Source

The printing company I am using requires the following headers:

Record Id,Salutation,First Name,Middle Name,Last Name,Name Suffix,Title,Business,Address 1,Address 2,City,State,Zip

So I need a script written that will allow me to easily merge the first file data with the appropriate field headers in the second file.

The fields that will need to be completed is the Record ID (1,2,3,4, etc). The data columns (fields) that need to be merged with the second excel file are:

First Name,Last Name,Address,Address2,City,State,Zip

let me know if you have questions

Skills: Data Processing, Excel, Software Architecture, Visual Basic

See more: merge excel worksheets without copying and pasting, combine multiple excel sheets into one sheet, merge excel files online, combine excel workbooks, combine multiple excel sheets into one macro, how to create a master schedule in ms project 2016, multiple projects in microsoft project 2016, how do you merge two excel spreadsheets together?, scan document excel word project, excel vba project 2007, excel regression project, excel vba project plan, excel college project, free excel spreadsheet project movement inventory, excel macro project daten importieren, excel search project, excel vba project search engine, advanced excel skills test questions, fun excel vba project, excel workbook project tracker

About the Employer:
( 12 reviews ) Knoxville, United States

Project ID: #17891398

70 freelancers are bidding on average $112 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Ex More

$200 USD in 2 days
(636 Reviews)
8.3
Eagles90

Dear Client, We are interested in your project and ready to go for it. We have read your job description carefully and understood the project. We have done similar projects so confident to handle this project. Yo More

$150 USD in 2 days
(116 Reviews)
7.5
schoudhary1553

This is Vibrant Webtech and I was glad to see that you're looking for help for project Excel Merge . I've delivered more than 400 + projects in the last 5 years and this makes me very confident with your task.I'd lik More

$150 USD in 2 days
(297 Reviews)
7.6
Webxpert4u

Hello, I am ready to create script so you can merge both files into one master sheet. Would be great if you can send me sample of 5 rows from both files. Lets chat. Highly experienced in Excel Programming, Excel aut More

$166 USD in 1 day
(207 Reviews)
7.6
deepbluetech

Hi, I can provided you with an Excel macro based solution to automatically merge the data from the csv file to produce the desired output. Kindly confirm and provide relevant sample file for testing. Thanks, Arul

$150 USD in 2 days
(253 Reviews)
7.4
asin1987

Dear Employer, Please message me. I will create an excel solution which will merge data from first file with the data in second file and will give the IDs for all. Do check my reviews for your reference. Thank More

$166 USD in 3 days
(126 Reviews)
7.1
paris2785

Hello! My name is Paris and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because this is my favorite field and MS Excel projects are among the tasks I work with More

$150 USD in 2 days
(166 Reviews)
6.8
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega More

$200 USD in 5 days
(214 Reviews)
6.8
MimiFL

Hello, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of merge/conversion projects without a single problem. If you are interested in working with me, please message s More

$72 USD in 0 days
(423 Reviews)
6.8
Piao217

Hi, I read your post with interest and I can handle it. I have developed many Windows desktop applications in various fields including Office Automation. Especially I have a very rich experience in Excel manipulation More

$155 USD in 1 day
(61 Reviews)
6.7
avinav606lx

Hello there, This looks feasible and I can do this quickly. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. P More

$98 USD in 1 day
(172 Reviews)
6.5
suyashdhoot

Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp More

$250 USD in 3 days
(53 Reviews)
6.5
polarjin2017

Hello? How are you? I have read your brief description. I have good skills in excel ... job... So I think we can work together. Hope to work with you. Thank you.

$133 USD in 3 days
(87 Reviews)
6.5
expertatwork

hi there, thanks for the heads-up. I can develop this simple script which transforms CSV from one form to the another. Please reply, thank you.

$30 USD in 1 day
(235 Reviews)
6.2
sonarkaushik

I am very able to create a vba macro to suffice your requirement. I am ready to start. regards

$99 USD in 2 days
(63 Reviews)
5.9
zu02

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. In your current project needs More

$155 USD in 3 days
(35 Reviews)
5.9
bianyunzhi95

Nice to meet you. I've read your project description carefully and I can do exactly what you want. I am a heavily experienced Python developer with strong backgrounds in Data Science. I think it could be done using More

$155 USD in 3 days
(30 Reviews)
5.3
datakillers

Hi, I have good Microsoft Excel skills with years of experience as well as I have complete number of projects for Excel to manage data and sorting. You can check my profile feedback section and you will know what my c More

$30 USD in 1 day
(44 Reviews)
5.2
supper5guy

Hello there, as an expert in excel and VBA, i can help you to accurately develop such a script for your data merging as you have specified. Please contact me and let us talk more about your project. Thanks

$50 USD in 2 days
(65 Reviews)
5.2
AlexandrUKR

i can send first version for your test within 1 day, please clarify possible next steps .

$155 USD in 3 days
(20 Reviews)
5.1