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
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
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.
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
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
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.
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.