Terminé

excel macro merge sheets

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

Compétences : Traitement de Données, Excel, Visual Basic, Visual Basic pour les apps

en voir plus : consolidate data from multiple worksheets in a single worksheet, how to combine multiple excel files into one worksheet using macro, combine multiple excel sheets into one sheet, macro to consolidate data from multiple workbooks, merge multiple excel files into one sheet vba, how do you merge two excel spreadsheets together?, merge excel worksheets into one master worksheet, consolidate worksheets wizard, excel macro selecting sheets print, macro print sheets excel, macro select sheets print excel, sample excel macro code filling excel sheets, average sheets excel macro, excel macro import sheets, summing cells sheets excel macro, mail merge excel macro, merge consolidate excel macro, excel macro merge files folder, excel macro merge files, excel macro merge

Concernant l'employeur :
( 77 commentaires ) Leipzig, Germany

Nº du projet : #17688911

Décerné à:

paulodayto08

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 pro Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(5 Commentaires)
2.7

12 freelance font une offre moyenne de $29 pour ce travail

schoudhary1553

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(284 Commentaires)
7.6
prameswara

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(320 Commentaires)
7.0
The24CarrotsInc

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(65 Commentaires)
5.7
mail2vimalarora

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(88 Commentaires)
5.7
vaibhavvats85

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
GoodmanCampbell

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,

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
honeyd02

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
juliuscordero

can you rearrange all columns including A-D after running the macro? I propose to re arrange column names alphabetically, sheets 1 and 2, so that when you append the data from shete 2 below sheet 1, it fits on the righ Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
graeserbjoern

Expert in Excel, I get it done quickly for you. Perfectly understanding needs and requirements :). Please message me to discuss details...

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0