Excel - create new sheet based on two separate sheets

Tamamlanmış İlan edilme: 3 yıl önce Teslim sırasında ödenir
Tamamlanmış Teslim sırasında ödenir

I have, for example, 20 excel sheets (all have only 3 rows of data) and within this group, there are sets of 2 sheets that relate to each other. I need a macro where I can enter the location of the sheets, plus name of the two related sheets and as a result I want a new sheet created for each set of 2. The new sheets will have two tabs.

Tab 1 - all info from the 3 rows on sheet1

Tab 2 - all info from the 3 rows on sheet2

New sheets needs a set naming convention based on the name of sheet1

New tabs on new sheet need similar naming convention.

Example sheets can be provided, showing original set of 2 sheets and the new result.

Excel

Proje NO: #27964349

Proje hakkında

26 teklif Uzak proje Aktif 3 yıl önce

Seçilen:

P0L

(435 Değerlendirme)
7.7

Bu iş için 26 freelancer ortalamada €17 teklif veriyor

masud0012

I can fix this issue in just a few hours Well met! I would be very happy to work with you. Kind regards, Masud

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(112 Değerlendirme)
6.0
nwss1986

Hi, I can start right now and can deliver in a couple of hours. can you please send me the excel file, you mentioned? Thanks and Regards.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(88 Değerlendirme)
5.5
imtyzooel71n

Hi, I can do this project with 100% accuracy right now. Can you share with me your sheet please? Thanks

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(43 Değerlendirme)
5.4
lxqcad

You can provide me the sample sheet. I can check it and write the macro probably even before you accept the bid.

€22 EUR in 2 gün içinde
(20 Değerlendirme)
4.8
MMG2019

Hi, I have more experiences in MS EXCEL and VBA. I can build your Macro as described. Feel free to discuss. Thanks

€30 EUR in 3 gün içinde
(15 Değerlendirme)
4.3
chintuag

Dear Hiring Manager, I have read the project details and and would like to offer my expertise for your project. I'm working daily on excel automation and have worked several projects using VBA. My expertise includes, Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(8 Değerlendirme)
3.9
jnpkfb

Hi there, I can do your project with 100% accuracy. I have reviewed your "Excel - create new sheet based on two separate sheets" project brief carefully and would like to assist you with the task. Please check via t Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(12 Değerlendirme)
2.7
WelcomeClient

***** 100% SATISFACTION ***** I am ready ***** Hello ! I have read your project description and I am pretty sure that i can pull off your project within the time limit and at the best price too.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(2 Değerlendirme)
2.1
theophilusjohn2

I believe I am good in using Excel. Please consider to avail my services for your cause. Thank you.

€19 EUR in 7 gün içinde
(0 Değerlendirme)
0.0
theonlinemarts

I can do this project. I will start your project right now. please share your project details. of you give me chance I can do for you in low cost with fast delivery.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0
yashbjs91

I have 5 years of experience out from freelancing as a data operator in a company & I was nominated as a best employee of the year in my company.

€8 EUR in 5 gün içinde
(0 Değerlendirme)
0.0
sayembinrouf123

Hi, Greetings of the day. Hope you are doing well. I am interested to work on your project. I will provide you the best quality work. About Me

€20 EUR in 6 gün içinde
(0 Değerlendirme)
0.0
jaysaliya2211

You are looking for a copy-pest master and I am one of them I can do your work at less price at you have fixed in less time

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0
Skleo26

hi dear i can read your project detail so i can offering that i am ready to take your project and i can complete within time and fast deliver your project so are you ready to take me your project email me thank yo Daha Fazla

€19 EUR in 7 gün içinde
(0 Değerlendirme)
0.0
priyankasamrat12

I will work a macro where I can enter the location of the sheets, plus name of the two related sheets and as a result.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0
sachinsiddhu55

I know I can deliver this project efficiently because i am excellent in using ms excel. i am working professional in excel.

€10 EUR in 3 gün içinde
(0 Değerlendirme)
0.0
shubhkchouriya

Ready to do in 1 day at lowest price. 4 years experienced hand in MS Excel. Your assurity is my priority. Let's start.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0
masoomshah22

Hey, I have read your fully read your project description very carefully and understood the required things for this project. I have an extensive experience in Microsoft Excel and have done the similar projects for man Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0
aryar3435

Hello sir I am data Entry expert i have understood your project details I will create excel macro file 100 % accurate and clean work Though I am a freelancer and new user but I have done lots of similar work on ot Daha Fazla

€25 EUR in 4 gün içinde
(0 Değerlendirme)
0.0
mlsukhadiya

I understood to your project. I do to my work with 100% of accuracy and loyalty. You may stay connected with me in the future after getting this project done.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0