Find Jobs
Hire Freelancers

Create one spreadsheet from many spreadsheet

$30-250 USD

In Progress
Posted over 9 years ago

$30-250 USD

Paid on delivery
I have 7 Excel Spreadsheets each with many colums, there is one main sheet, the rest provide information for certain field I require all data copied using a macro or an automated process to merge data. NO MANUAL INPUT ALLOWED as this process will be run by us on a weekly basis. Final spread sheet needs to have all information on a per line basis. EG main spreadsheet has 100 prodcucts with code 5000, image spreadsheet has 1 row with 5000, end result every line in main file needs the image name in a field. Basically all data from sub sheets will be added to every row as require so when looking at main sheet on a row will be every bit of data from every file. I will add test files, these are a very cut down version, in the main Test Data file, I have put a few products, the file file will have 40,000+ products to work with. As I have had many say they can do this and not deliver, the requirement to show you can do the job is I need a result file from you, you can remove all your coding so I have to award the project. You system has to work many times, the main test file will change every week and therefore your process has to be able to cope with this. Ask sensible questions please, don't through lots of links at me, I am not interested in websites or anything like that, I just want someone to merge the data.
Project ID: 6873391

About the project

22 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
22 freelancers are bidding on average $112 USD for this job
User Avatar
Hello Sir - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects and very high completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay
$160 USD in 0 day
5.0 (862 reviews)
9.3
9.3
User Avatar
Dear Hiring Manager, Thank you for this wonderful opportunity. Your job post has caught my attention because I'm article writing addict and I’m considering your job for me with these required capabilities. I have excellent experience in article writing in English language. I have good command over English grammar, English Basic Skills, English Spelling, English Vocabulary, U.S. English Sentence Structure, U.S. English Punctuation, Direct & Indirect Narration, Active Voice & Passive Voice, Conjunctions, Prepositions, Prepositional phrases, Verb phrases, Tenses, Noun phrases, Pronouns, Adverbs, Adjective phrases, and other grammar related topics. I have already written many articles such as academic writing, report writing, article writing done lots of assignment , research proposal and I can provide you samples. I believe my capabilities would be perfect for your project. I can finish this job within the necessary interval. I have one year of experience in this field. “Moving forward, I can commit 30-40 hours/week for your job, and my everyday time are flexible. I’m very motivated to provide my services for your job. You can contact me immediately to discuss this position further.” I have done these following tasks: Assignment: Green Movement, Multiple cultures, Strategic Management. Article: History, Technology, Research proposal, Dissertation on Business management Regards Motiur
$100 USD in 3 days
4.9 (271 reviews)
7.8
7.8
User Avatar
Hi, I can code a macro where you will have first to select the input files to be merged (via the Windows user form). After that the macro will merge the sheets and generate the final (main) file. I just need to understand the logic of the merge process. If all is clear, the macro can be coded in 1 day. Thanks
$66 USD in 2 days
5.0 (322 reviews)
7.8
7.8
User Avatar
Hi Sir. I can do merge data from many excel to one excel. I haver created a macro before like that. please awarded me , and i will finih it ASAP. i'm excel expert. please see my portfolio. Thanks Prameswara :)
$55 USD in 3 days
4.9 (412 reviews)
7.6
7.6
User Avatar
A proposal has not yet been provided
$242 USD in 5 days
4.9 (252 reviews)
7.2
7.2
User Avatar
Hello there, I will be glad to help you out with this project. I have experiences using Excel with macros so I assure you excellent results in a short time period. I would like to talk to you so I hope to hear from you soon. Thanks, Daniel
$50 USD in 1 day
4.8 (94 reviews)
7.1
7.1
User Avatar
A proposal has not yet been provided
$50 USD in 3 days
4.9 (204 reviews)
6.4
6.4
User Avatar
Hi I would love to work on this project. I have 5 years of experience in the field of Microsoft Excel. Please contact with further details if interested. Regards Raghav Bansal
$111 USD in 3 days
4.9 (95 reviews)
6.6
6.6
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
$126 USD in 1 day
4.9 (165 reviews)
6.5
6.5
User Avatar
Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have been freelancing for over 2 years. But I joined this site just a month ago. Within a month I won two of tough contests held on this site. This says a lot about the quality of my services. I have worked on lot of advance excel dash boarding and VBA coding and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.
$150 USD in 3 days
4.9 (18 reviews)
5.7
5.7
User Avatar
Hello sir, Please give me the chance to help you. I am an excel and VBA expert. In Visual Basic I can create a macro that can do this automatically,with condition that when you will run it next time, the columns from all spreadsheets to be in the same position,and with the same name. Kind regards, Dragos!
$80 USD in 0 day
5.0 (85 reviews)
5.7
5.7
User Avatar
Hi there! I have done more than a few projects like this and can deliver the final consolidated file quickly and accurately. My reviews are testament to my excel skills. I would be interested and happy to do this! Please feel free to ping me with the data of your choice and I will send you a quick sample that would be done with complete automation (zero manual effort) for your review and then you could decide to award the project based on the sample work! Thanks! -Steve
$75 USD in 0 day
5.0 (81 reviews)
5.8
5.8
User Avatar
Dear Project Manager, My Data Entry Skills encouraged me to work as a Freelancer. I have great potential & passion to work here. Constant work is my core objective. You can revert me back to have quality output. Feel free to ask me for sample... Regards, Abdullah Zaib
$45 USD in 3 days
5.0 (7 reviews)
4.8
4.8
User Avatar
Greetings for the Day!!! i have 5 years of experience in Data entry and typing , Excel macro, VB script and VB application creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. hope if awarded with this project i can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details Thanks Prabakar M
$83 USD in 1 day
5.0 (48 reviews)
4.6
4.6
User Avatar
Hi, programmer and data scraper here with over 17 years experience in programming and RDBMS - please see my reviews. I'm using Perl for this kind of jobs. I'm able to extract data fast.
$166 USD in 3 days
0.0 (2 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, i am interested in doing your project , i can dot it properly and on time with the help of your guidance. Regards
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear employer as I'm well expert I can Handel the project and provide you the result within the given time frame. As before also I just finished one local project of one restaurant. this is the ending of the year so they are also having the same thing as your. looking for the response. best regards indra
$150 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$177 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I bid just for the first file. If you will be satisfied we will speak about the pricing. With kind regards Lukas Svoboda
$35 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Folkestone, United Kingdom
4.9
17
Payment method verified
Member since Apr 10, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.