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.
45 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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.
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
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!
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.