已完成

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

技能: 数据处理, Excel, Visual Basic, Visual Basic的应用程式

查看更多: 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

关于此雇主:
( 77个评论 ) Leipzig, Germany

项目ID: #17688911

授予:

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 更多

$20 USD 在1天内
(5条评论)
2.7

12 威客就此工作平均出价 $29

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 更多

$60USD 在1天里
(284条评论)
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

$30USD 在1天里
(320条评论)
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 更多

$25USD 在1天里
(65条评论)
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 更多

$30USD 在1天里
(88条评论)
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.

$25USD 在1天里
(0条评论)
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,

$25USD 在1天里
(0条评论)
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.

$33USD 在1天里
(0条评论)
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 更多

$25 USD 在2天内
(0条评论)
0.0
$25USD 在1天里
(0条评论)
0.0
$25USD 在1天里
(0条评论)
0.0
graeserbjoern

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

$20USD 在1天里
(0条评论)
0.0