Hello all,
I need to find a solution for this purpose :
I have 3 Files, with the same columns' names and same structure, but different information.
2 files have 2 sheets. 1 file has only one sheet.
My Questions :
1. How can I merge the 3 files into one, with an adding column precising me from witch file the information was taken ?
2. Is there any other solution in this case : if i regroup the 3 files in one file (so 5 sheets in one file : 2 sheets from file 1, 2 others from file 2, 1 sheet from file 3), and then merging all the sheets in a new sheet of the same file ?
Thank you so much.
Bookmarks