Find Jobs
Hire Freelancers

excel macro merge sheets

$10-30 USD

Completed
Posted over 5 years ago

$10-30 USD

Paid on delivery
I need a macro merging excel sheets. The sheets have some "fixed columns" which have the same data headlines through all sheets . Then there are columns E:{varying by sheet - up to several hundred}. Some of these column headlines overlap, i.e. they have the same name, but these names may be within different columns, such as "book..." is in column G in sheet1, and "book..." is in column L in sheet2. What the macro shall do when merging the sheets: copy the entries of sheet 2 below sheet 1, sort the columns E:[{varying by sheet} below that, whereas the same headline appears below the same headline, such as "book" now all in column G. Headlines which appear in the second sheet but are nonexistent in the first sheet shall be added at the right of the columns of sheet 1. So in case sheet 1 contains columns E:G (3 columns), and sheet 2 contains E:L (eight columns), with only the "book..." column overlapping, the new sheet shall have columns A:D (fixed) and then column E:F with data from sheet 1 only, column G with "book..." data from both sheets, and columns H:N with data from sheet2 The macro shall have the possibility to merge more than one sheet as well, so in case of e.g. three sheets, merging sheet 1&2 first, and then the results of this "temp" sheet are merged with sheet 3. More details are provided in a chat discussion
Project ID: 17688911

About the project

10 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
Hi Good Day! I can help you to complete this work in less than a day. I am a PMO analyst for 8 years now. I am also a SME in different tools like Ms Project, Excel and Sharepoint. I also part of the team that do process improvements and automation for Financial and Metrics report using VBA macro. Feel free ro message me to discuss more about this project
$20 USD in 1 day
4.9 (35 reviews)
4.4
4.4
10 freelancers are bidding on average $29 USD for this job
User Avatar
Hello, I have the good knowledge of excel macro merge sheets. I have more than 5 years of experience in Data Processing, Excel, Visual Basic, Visual Basic for Apps. I have reviewed your job and can deliver you the job with 100% satisfaction. Please ping me for more discussion.
$60 USD in 1 day
4.9 (333 reviews)
7.9
7.9
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i can make macro for merge all your sheet via VBA macro excel please give me this job and im able to start working today Thank You Sincerely Galih AP
$30 USD in 1 day
4.9 (372 reviews)
7.2
7.2
User Avatar
Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc VBA/EXCEL 100% Satisfaction Of Deliverable
$25 USD in 1 day
4.9 (69 reviews)
5.8
5.8
User Avatar
Hi, Being experienced in working on several excel VBA projects, I can help in getting code done that will work for merging sheets as per your requirement given. I have worked on similar project which reads data from several files and arrange into different sheets based on its type. Waiting for your response on chat for further discussion in detail. Thanks.
$30 USD in 1 day
4.8 (109 reviews)
5.9
5.9
User Avatar
I have experience in MS excel for more than 2 years and other SQL databases such as Oracle 11g, MySQL and NoSQL databases such as Mongo db.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have a wide experience in excel functions. I can help you with this project right away. Please share the document with me right away. Thanks,
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I propose to deliver your job in 24 hours. Relevant Skills and Experience I have expert knowledge on Excel spreadsheets and i am very efficient and effective in what i do.
$33 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Expert in Excel, I get it done quickly for you. Perfectly understanding needs and requirements :). Please message me to discuss details...
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Leipzig, Germany
5.0
89
Payment method verified
Member since Nov 17, 2011

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.