Find Jobs
Hire Freelancers

Excel files merger

$30-250 USD

Finalizat
Data postării: peste 3 ani în urmă

$30-250 USD

Plata la predare
We want to have a way to merger multiple excel sheets into 1 master excel file. this is typically easy BUT as you look at my example files attached, they ALL have the bottom of the sheets filled with data that is NOT the same across multiple excel sheets and they are NOT in the same rows. It is ALWAYS the last 4 rows that have data, merged cells that does NOT need to be merged. All of columns are always the same. We want a way to open a default excel sheet you would create and we click on a button that creates an action to allow me to select various excel sheets (ideally more than 1 excel sheet at a time) and click import. When I do this, all of the columns from A-R (even though Q and R are typically empty they are still imported) are imported from the various excel sheets into one table. This will be used for various amounts of excel sheets moving forward so this is NOT a 1 time use. each time I do this, there will be various amounts of excel sheets and each excel sheet will have various amounts of rows.
ID-ul proiectului: 28415271

Despre proiect

40 propuneri
Proiect la distanță
Activ: 3 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
Acordat utilizatorului:
Avatarul utilizatorului
$0 USD în 2 zile
5,0 (159 recenzii)
7,5
7,5
40 freelanceri plasează o ofertă medie de $131 USD pentru proiect
Avatarul utilizatorului
Hi,I am an Excel Expert with Professional experience working with Excel. I have more than 10 year experince with excel. Complete a lot of jobs on Freelancer with highly satisfaction of client. I believe I can do a great work for you and ensure your quality.
$30 USD în 1 zi
4,9 (700 recenzii)
8,4
8,4
Avatarul utilizatorului
Hi, Greetings! ✅checked your project details: Excel files merger ✅Completed Time: In project deadline We have worked on 640 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast
$220 USD în 4 zile
4,9 (561 recenzii)
8,5
8,5
Avatarul utilizatorului
**********************Hi there************************* Understood perfectly your requirements, I have a ready made file, it is basically a userform with so many features, if u want to have a look i can share. it is called consolitaion Master it has a option to select a folder. Thnaks much, Rk
$149 USD în 1 zi
5,0 (582 recenzii)
8,0
8,0
Avatarul utilizatorului
Hello, this is very common project, merging multiple sheets with same structure into a single combined file. If you are interested in working with me, feel free to message me, so i can clarify few things about the merged rows at the bottom, and i can complete this for you immediately. And yes it will be automated solution that you can run yourself whenever you need to. Thanks, Milan
$40 USD în 1 zi
5,0 (732 recenzii)
7,4
7,4
Avatarul utilizatorului
Hi There, I checked your attached excel files. I will create a master excel file by matching the column names of each excel files. Best Rakib
$30 USD în 1 zi
5,0 (235 recenzii)
6,9
6,9
Avatarul utilizatorului
EXCEL F EXPERT------------------ I CAN START RIGHT AWAY --------------- Hello sir, I have read your project details carefully. I can help you this merge work with this project by maintaining 100% accuracy of your data absolutely as you want. ----- I can start right now, please message me to discuss more. Regards, MA Hossain
$30 USD în 1 zi
5,0 (392 recenzii)
6,8
6,8
Avatarul utilizatorului
I can perfectly develop such an Excel based tool to merge files. I am an advance level Excel expert holding years of experience. I will be happy to discuss in detail.
$200 USD în 1 zi
4,8 (190 recenzii)
7,1
7,1
Avatarul utilizatorului
Hi, As I understand you are looking for a way to merge various Excel files. I am planning to develop this using Excel VBA. Please suggest suitable time to discuss on this. I am well versed with Excel macros for automation and keen to work on this. Looking forward to your response. Thanks
$75 USD în 4 zile
4,9 (196 recenzii)
6,8
6,8
Avatarul utilizatorului
NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed projects which involved Programming, scripting, excel macros. Key features of my work are as follows: 1) Always within schedule 2) Always within scope 3) Best tools and techniques used for the completion of tasks Looking forward to hear from you. Regards
$120 USD în 3 zile
4,8 (79 recenzii)
6,2
6,2
Avatarul utilizatorului
Hi, I have more experiences in Visual Basic, MS EXCEL and VBA. I can write VBA code to do this merge with all your requirements and needs. Feel free to discuss . Thank you.
$250 USD în 3 zile
5,0 (61 recenzii)
5,7
5,7
Avatarul utilizatorului
Hi There, I can develop excel sheet with VBA to import excel sheet with different column and rows. Please contact me for further discussion Thank you
$111 USD în 2 zile
5,0 (36 recenzii)
5,2
5,2
Avatarul utilizatorului
I can do this. I have good command over Ms excel especially pivot table, charts, advance formulas, formatting etc. Please review my profile and inbox me for detail. Thanks Abdul Haleem
$150 USD în 2 zile
4,9 (36 recenzii)
5,0
5,0
Avatarul utilizatorului
Hi there, This sounds like an interesting project and I would like to upgrade the master file for you. With over 10 years of experience in working with Excel (with a focus on the automation and streamlining of processes), I will create your personal solution that fits your needs. I am reliable, work thoroughly and with an eye for detail, stick to my deadlines and deliver high quality solutions. I look forward to having a chat about the details. Warm regards, Nadja
$100 USD în 5 zile
5,0 (8 recenzii)
4,3
4,3
Avatarul utilizatorului
I'm a specialist in Excel and macros programming. I think we can identify different patterns in vba for each file to make an automaton possible. PM and we can discuss.
$80 USD în 3 zile
5,0 (15 recenzii)
3,8
3,8
Avatarul utilizatorului
Hi, I'm expert in data entry work I 'm very fast available 12 hrs daily accuracy 100% Greetings.......
$100 USD în 5 zile
4,4 (25 recenzii)
3,7
3,7
Avatarul utilizatorului
Proposal For [Automated Merging of excel files/Jacob Lesson Software Solutions] Dear potential client, I understand you would like a program to automate the process of merging the contents of your excel files when you import them. This is a very common task. I have experience writing programs just like this all I would have to do is change a few parameters in previous work to match your requirements. This program would be adaptable for future use. I would accomplish this using a vba windows program. I appreciate the opportunity to send this proposal and look forward to working with you. Sincerely, Jacob Leeson
$30 USD în 2 zile
5,0 (5 recenzii)
2,9
2,9
Avatarul utilizatorului
Hi, I am an expert in excel data analysis, processing and manipulation. I am adept in VBA macro programming for data transformation as well. I can write a macro that reads all the rows from the files append them except for the last 4 rows. The consolidated results can be saved a worksheet and the whole process can be automated. Kindly contact to discuss further. Looking forward to start working.
$30 USD în 2 zile
5,0 (10 recenzii)
2,8
2,8
Avatarul utilizatorului
Hello, I'm Alexandre, a senior data analyst living in France, I’m usually working on development/coding projects, but as a French native i can help you on this ! I have downloaded your examples, if I understed it right, you want to get all the Unit Price / Total / Discount / Grand total from every files you want ? I can achieve that for you :) I can build you an Excel tool that will allow you to select multiple files, and get all the data you need from it. Feel free to contact me so we can discuss it ! Best regards, Alex.
$200 USD în 4 zile
2,3 (7 recenzii)
4,8
4,8
Avatarul utilizatorului
__________________I am available right now______________________ Hi there, Quality and time is my commitment. I have done this many times, I want to say that, I will start right now and funds will be after your satisfaction. Consider!
$150 USD în 2 zile
5,0 (5 recenzii)
2,2
2,2
Avatarul utilizatorului
Dear Requestor, Im experienced Data and Business analyst with 15+ experience, including project management skills (Excel/PowerPivot/PowerQuery/Google sheets). My area of expertise are: ● Datasource cleaning and combining ● Automation ● Reports and Dashboard creation ● Old files bug fixing ● Advanced formulas creation ● Formatting ● Presentations design and much much more. Challenges with the excel data? Need a quick bugfix with formulas? Request a new report/dashboard data model? Need to combine and clean multiple sources for reporting package? Easy! Business users spend up to 80 percent of their time on data preparation/reports updating, which delays the work of analysis and decision-making. Personally, Im offering: ● Clear and transparent communication I am fluent in English which is a must when I want to understand what you need ● Time management- My slogan is 'Just in time' so you will have what you need when you need it. ● Quality- You want to solve your problems quickly, but the solution needs to be complete. You don't want to spend time on dealing with bugs and half solutions. Also you can contact me anytime in case of any questions. I will send you resume upon to your request. Looking forward for your challenges and Im glad to offer you my pragmatic approach, experiences and competencies. Best regards, Maks
$140 USD în 1 zi
5,0 (1 recenzie)
0,8
0,8

Despre client

Steagul UNITED STATES
Athens, United States
5,0
23
Metoda de plată a fost confirmată
Membru din feb. 27, 2006

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.