Merging files, workbooks

[Ayda]

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.

[Naveed Raza]

Hi Ayda welcome to the Forum !!!

about your query , u mean to say sometime u will have multiple sheets in some files right and all the sheets to be add to consolidate file right & then after all the sheets in one sheet in same is it right..


Just please confirm your data will start from 2nd row only ??

if its so then I will be back in 15mins with the solution

[Naveed Raza]

Merging File_Macro 05MAY2015.xlsbHi Ayda

as required, please find the attached macro file.

Steps:
1. Place the path in Setup Sheet where all the files are there which need to be merge (note: place only that files which need to merge in assign path)
2. click on the button

Note: make sure u data should start from 1st row (including header).

Hope this will work for you

[Ayda]

Hey Naveed,

Thank you for your help, but your solution didn't work on my computer maybe I did something wrong, a mistake... but I found an excellent solution : DigBD ! And finally it works !

Thank you Naveed for your patience and help with me.

[Naveed Raza]

if my solution help you and you got your solution please mark the thread as SOLVED and click on *Add Reputation to say Thanks