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
70 freelancers are bidding on average $112 for this job
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
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.
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