Suoritettu

Merge Excel files from different folders

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.

Taidot: Excel

Näytä lisää: how to combine multiple excel files into one worksheet using macro, how to merge multiple excel files into one workbook 2010, merge excel files online, merge multiple excel files into one sheet vba, combine multiple excel files into one workbook vba, merge multiple excel sheets into one workbook, macro to consolidate data from multiple workbooks, combine multiple excel sheets into one macro, merge excel files macro, merge excel files sheet, merge excel files file, merge excel files common data, merge excel files remove duplicate, merge excel files duplicates, merge excel files using vbs

Tietoa työnantajasta:
( 0 arvostelua ) Osasco, Brazil

Projektin tunnus: #16120176

Myönnetty käyttäjälle:

P0L

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 3 päivässä
(229 Arvostelua)
6.9

45 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

KulfiSoftwares

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 3 päivässä
(201 arvostelua)
7.2
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. Best regards

R$500 BRL 5 päivässä
(177 arvostelua)
6.7
expertatwork

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 2 päivässä
(143 arvostelua)
5.8
vlayausa

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 1 päivässä
(115 arvostelua)
5.7
caabdul

Hi there, Consider it done. Thanks you

R$300 BRL 7 päivässä
(43 arvostelua)
5.7
SShtv

I have a large and successful hands-on experience in processing and analyzing data in Excel, as well as visualizing the data and constructing information panels. This is a screenshot of one of my works. https://drive Lisää

R$150 BRL 1 päivässä
(46 arvostelua)
5.3
R$500 BRL 3 päivässä
(89 arvostelua)
5.5
polarjin2017

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 3 päivässä
(22 arvostelua)
5.2
aubrey03

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 2 päivässä
(19 arvostelua)
4.8
Nada100200

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, Ja Lisää

R$90 BRL 3 päivässä
(6 arvostelua)
4.5
vano101

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 - Lisää

R$150 BRL 3 päivässä
(17 arvostelua)
3.7
ongskjason

A proposal has not yet been provided

R$360 BRL 2 päivässä
(4 arvostelua)
3.4
K9JT

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 d Lisää

R$100 BRL 3 päivässä
(12 arvostelua)
3.2
haleem0786

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 2 päivässä
(6 arvostelua)
2.7
jawadrafia

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 Lisää

R$300 BRL 3 päivässä
(3 arvostelua)
2.5
R$115 BRL 3 päivässä
(4 arvostelua)
2.1
AMPaunescu

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 accura Lisää

R$500 BRL 2 päivässä
(4 arvostelua)
1.9
venkatrdr

A proposal has not yet been provided

R$555 BRL 3 päivässä
(2 arvostelua)
1.6
hatemwaheed

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 3 päivässä
(3 arvostelua)
1.0
natm0411

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 lab Lisää

R$222 BRL 5 päivässä
(0 arvostelua)
0.0