Find Jobs
Hire Freelancers

excel macro merge sheets

$10-30 USD

Imekamilika
Imechapishwa over 5 years ago

$10-30 USD

Kulipwa wakati wa kufikishwa
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
Kitambulisho cha mradi: 17688911

Kuhusu mradi

10 mapendekezo
Mradi wa mbali
Inatumika 6 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
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 ndani ya siku 1
4.9 (35 hakiki)
4.4
4.4
10 wafanyakazi huru wana zabuni kwa wastani $29 USD kwa kazi hii
Picha ya Mtumiaji
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 ndani ya siku 1
4.9 (333 hakiki)
7.9
7.9
Picha ya Mtumiaji
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 ndani ya siku 1
4.9 (372 hakiki)
7.2
7.2
Picha ya Mtumiaji
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 ndani ya siku 1
4.9 (69 hakiki)
5.8
5.8
Picha ya Mtumiaji
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 ndani ya siku 1
4.8 (109 hakiki)
5.9
5.9
Picha ya Mtumiaji
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 ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
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 ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
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 ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Expert in Excel, I get it done quickly for you. Perfectly understanding needs and requirements :). Please message me to discuss details...
$20 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya GERMANY
Leipzig, Germany
5.0
89
Njia ya malipo imethibitishwa
Mwanachama tangu Nov 17, 2011

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.