Excel - create new sheet based on two separate sheets

Completed Posted 3 years ago Paid on delivery
Completed Paid on delivery

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

Project ID: #27964349

About the project

26 proposals Remote project Active 3 years ago

Awarded to:

P0L

(435 Reviews)
7.7

26 freelancers are bidding on average €17 for this job

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

€10 EUR in 1 day
(112 Reviews)
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.

€15 EUR in 1 day
(88 Reviews)
5.5
imtyzooel71n

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

€10 EUR in 1 day
(43 Reviews)
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 days
(20 Reviews)
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 days
(15 Reviews)
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, More

€26 EUR in 1 day
(8 Reviews)
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 More

€8 EUR in 1 day
(12 Reviews)
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.

€10 EUR in 1 day
(2 Reviews)
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 days
(0 Reviews)
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.

€8 EUR in 1 day
(0 Reviews)
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 days
(0 Reviews)
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 days
(0 Reviews)
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

€10 EUR in 1 day
(0 Reviews)
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 More

€19 EUR in 7 days
(0 Reviews)
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.

€10 EUR in 1 day
(0 Reviews)
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 days
(0 Reviews)
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.

€8 EUR in 1 day
(0 Reviews)
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 More

€15 EUR in 1 day
(0 Reviews)
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 More

€25 EUR in 4 days
(0 Reviews)
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.

€18 EUR in 1 day
(0 Reviews)
0.0