Find Jobs
Hire Freelancers

Merge Excel files from different folders

R$90-750 BRL

Completed
Posted about 6 years ago

R$90-750 BRL

Paid on delivery
I have 18 sales people and 18 shared dropbox folders with one excel file in each. Each excel file has the same column titles. I wish to merge these files into one master file where I can use pivot tables to analyse the data. I have seen various youtube videos on how to do this using power query but only for multiple files in one folder. Cannot find how to do this when I have one file per folder. Would like to press update to have any changes which have been made in each salesman`s folder automatically updated to my master file.
Project ID: 16120176

About the project

42 proposals
Remote project
Active 6 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
Awarded to:
User Avatar
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.
R$500 BRL in 3 days
4.9 (325 reviews)
7.3
7.3
42 freelancers are bidding on average R$342 BRL for this job
User Avatar
I love excel automation.. I can create a macro within master sheet, to pull data from all the 18 folders. ZERO ERROR GUARANTEED!! Please read my 300+ reviews. I am here to impress you with my work.
R$350 BRL in 3 days
4.9 (280 reviews)
7.5
7.5
User Avatar
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. Best regards
R$500 BRL in 5 days
4.9 (229 reviews)
6.9
6.9
User Avatar
Hello? How are you? I have good skills in excel. So i can help you then. I will never disappoint you. I have good skills in Thanks.
R$466 BRL in 3 days
4.8 (91 reviews)
6.7
6.7
User Avatar
Hello! I am proficient with Excel and VBA and have a lot of experience with similar projects. I would love to help you with this one. Please contact me for more information.
R$500 BRL in 1 day
4.9 (130 reviews)
5.8
5.8
User Avatar
Hi there, Consider it done. Thanks you
R$300 BRL in 7 days
4.8 (49 reviews)
6.1
6.1
User Avatar
I can do this using Excel VBA. The macro will open each file and copy the data you need in to your master workbook.
R$750 BRL in 2 days
4.8 (125 reviews)
6.0
6.0
User Avatar
Yes, I can develop a simple code to merge data of Excel files from different folders, please reply, we can discuss further and get it started soon. Thank you!
R$135 BRL in 2 days
4.8 (145 reviews)
5.8
5.8
User Avatar
Hello. I have strong experience with Excel VBA and macros and I have ideas how to solve it, I would like to just have 2-3 files in order to test on my machine. Second thing - I would like more about folder structure - because searching on entire disk is pretty slow
R$150 BRL in 3 days
4.9 (34 reviews)
4.7
4.7
User Avatar
Hello client. Hope you are doing well Over 8 +years experience writing almost exclusively web scraping code. I've done it all. I can scrape all LinkedIn profile My languages in order of experience and use is Python, JavaScript, PHP. Python libraries ( selenium, Lxml, BeautifulSoup ). I am also experienced in data entry,Excel, internet research, research, Scraping,Crawling and Scraping tools, LinkedIn, leads, Python,PHP, Software architecture,software Development, phpand other scripts,Data Processing,Data Entry,Excel,,Web Search,Data Mining,Data Science,lead collection. I have great experience of extracting information from websites i.e. Clients willing to have long term project relationship are most welcome. Thanks.
R$90 BRL in 3 days
4.7 (7 reviews)
4.6
4.6
User Avatar
A proposal has not yet been provided
R$360 BRL in 2 days
5.0 (7 reviews)
3.8
3.8
User Avatar
I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, charts, advance formulas etc. thanks
R$500 BRL in 2 days
4.9 (24 reviews)
4.0
4.0
User Avatar
Hi Please consider my proposal as I have extensive experience with excel spreadsheets and vba macros. In fact, I have already completed a project very much like this not too long ago for someone. It was a church document that had files in different folders and I created an update function for him to consolidated different data from all these files into one. I would also really appreciate working with you in order to grow my freelancing career. Kind regards John
R$100 BRL in 3 days
5.0 (13 reviews)
3.2
3.2
User Avatar
Hi there: By viewing the project "Merge Excel files from different folders", i am offering my services. I am university qualified professional having 10 years experience in working with Ms-Excel, by understanding the project, i will do the following work for you in Excel: 1. I will merge your data of all sales persons data in one master file by using power query and power pivot 2. Master data can be refreshed against each and every change in individual sales person file 3. Load and save data from power query to Basic Excel sheet for using pivot tables by you. I am expert in any type of data work in Excel and you will be amazed to see my professional services. Following points make me differ from others: a. Quality of work b. Accuracy, reliability and timeliness c. Client's satisfaction For further discussion, i am available on the platform of freelancer.com and proud to serve you better and better. Regards,
R$300 BRL in 3 days
4.9 (3 reviews)
2.5
2.5
User Avatar
Hey! I checked your requirements and I’m confident I can deliver high-quality work within your deadline and budget. I do this kind of work daily at my job as a Financial Auditor. I have great Excel skills and accuracy and speed are guaranteed. (10+ years of exp.). Take a look at my Freelancer Profile & Portfolio. Please contact me to discuss more about your project.
R$500 BRL in 2 days
4.6 (5 reviews)
1.9
1.9
User Avatar
A proposal has not yet been provided
R$555 BRL in 3 days
5.0 (2 reviews)
1.5
1.5
User Avatar
i read your requirements carefully, and i am willing to do this job in high efficiency and accuracy,look forward to hearing from you,regards.
R$630 BRL in 3 days
5.0 (3 reviews)
1.0
1.0
User Avatar
I have a very good experience with Excel. I'm familiar with all of its methods and functions. I'll try to fulfill the project requirements as soon as possible.
R$222 BRL in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I am working in MI reporting team and have working experience of 5+ year's in excel. Kindly send me the files so that I could complete it by Monday day end. Thanks Sumit Daga Relevant Skills and Experience I have 5+ years of experience working on excel and is currently working in reporting team which requires me to work on these things daily.
R$722 BRL in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
R$222 BRL in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have the hability of working with excel very easily, I'm very good with time management, organization and responsibilities. I'm always open to learning new things and gaining experiences that make me grow in a laboral and personal way. I hope I can help with everything needed and I will give my best at any task given. Thank you.
R$222 BRL in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BRAZIL
Osasco, Brazil
5.0
2
Payment method verified
Member since Jan 20, 2018

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.