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.
26 freelancers are bidding on average €17 for this job
***** 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.
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.