merging files

aswathy0001

New member
Joined
Nov 29, 2016
Messages
24
Reaction score
0
Points
0
Location
india
Excel Version(s)
2010
hi
i need a vba code

i have more than 10 files in a folder
each file have sheet1 Original and sheet2 Duplicate
i need to merge all the original sheet in a new workbook sheet1-original and all the sheet2-duplicates in the same workbook sheet2
is it possible any one?

thanks
 
Back
Top