Find Jobs
Hire Freelancers

Merge Excel files from different folders

R$90-750 BRL

Terminado
Publicado hace alrededor de 6 años

R$90-750 BRL

Pagado a la entrega
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.
ID del proyecto: 16120176

Información sobre el proyecto

42 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 3 días
4,9 (325 comentarios)
7,3
7,3
42 freelancers están ofertando un promedio de R$342 BRL por este trabajo
Avatar del usuario
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 en 3 días
4,9 (280 comentarios)
7,5
7,5
Avatar del usuario
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 en 5 días
4,9 (229 comentarios)
6,9
6,9
Avatar del usuario
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 en 3 días
4,8 (91 comentarios)
6,7
6,7
Avatar del usuario
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 en 1 día
4,9 (130 comentarios)
5,8
5,8
Avatar del usuario
Hi there, Consider it done. Thanks you
R$300 BRL en 7 días
4,8 (49 comentarios)
6,1
6,1
Avatar del usuario
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 en 2 días
4,8 (125 comentarios)
6,0
6,0
Avatar del usuario
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 en 2 días
4,8 (145 comentarios)
5,8
5,8
Avatar del usuario
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 en 3 días
4,9 (34 comentarios)
4,7
4,7
Avatar del usuario
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 en 3 días
4,7 (7 comentarios)
4,6
4,6
Avatar del usuario
A proposal has not yet been provided
R$360 BRL en 2 días
5,0 (7 comentarios)
3,8
3,8
Avatar del usuario
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 en 2 días
4,9 (24 comentarios)
4,0
4,0
Avatar del usuario
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 en 3 días
5,0 (13 comentarios)
3,2
3,2
Avatar del usuario
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 en 3 días
4,9 (3 comentarios)
2,5
2,5
Avatar del usuario
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 en 2 días
4,6 (5 comentarios)
1,9
1,9
Avatar del usuario
A proposal has not yet been provided
R$555 BRL en 3 días
5,0 (2 comentarios)
1,5
1,5
Avatar del usuario
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 en 3 días
5,0 (3 comentarios)
1,0
1,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
R$222 BRL en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 5 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de BRAZIL
Osasco, Brazil
5,0
2
Forma de pago verificada
Miembro desde ene 20, 2018

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.