How to consolidate excel files with different sheet names and merge in a single file
test1.xls (23 KB)
test1.xls (23 KB)
Thanks
Ashwin S
How to consolidate excel files with different sheet names and merge in a single file
test1.xls (23 KB)
test1.xls (23 KB)
Thanks
Ashwin S
It has another file as test 2 with sheet name as UM2
Thanks
Ashwin S
Buddy @AshwinS2
will those be same excel file with different sheets or different excel files with sheets in them
Cheers
Hi @Palani
I DO HAVE DIFFERENT EXCEL FILES AS TEST1.XLS WITH SHEET NAME AS UM1 AND TEST2.XLS WITH UM2 SHEET NAME I WANT TO MERGE THAT INTO SINGLE FILE
THANKS
ASHWIN S
Hi @AshwinS2
I have created workflow based on your requirement here I used your attached two excel files.
1.First excel file(test1.xls) sheet name UM1.
2.Second excel file(test2.xls) sheet name UM1
3.Finally I merged above two files and save to Output.xls file
MergeTwoExcelFiles.zip (20.0 KB)
.
Thanks for the post
Thanks
Ashwin.S
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.