i have 60 workbook in a folder, then i want to select 2 workbook for merging one after another ie:- 2 sheets one after another not in one worksheet, hence finally 30 workbook with 2 sheets each and the name of the worksheet can be preserve


eg:- i have test.xlsx & test1.xlsx final result in newexcel.xlsx ie:- newexcel.xlsx in sheet1 & test1.xlsx in sheet2

can it be done

i have post the same on other forum

https://www.mrexcel.com/forum/excel-...er-folder.html