coppy data to master sheet

0

hello dears

 this is first question for me.

 i have foldar contains many sub folders each one contain from 25 to 30 excel workbook (.xls, .xlsx) i want to open each one of them and coppy its data range to the masterWorkBook (paste all, transpos),
and if available i want to combine some cills together like we do using (=b5&"  "&b6) furmula.

as it explain in attached files.

vba macro will be added to the master_workbook file.

 will be great if the code will be run on all excel versions.

  thanks for support.

Answer
Discuss

Discussion

This is a forum for teaching Excel. What do you wish to learn?
Variatus (rep: 1815) Jan 22, '18 at 8:47 am
Egy, will the data be located in the same place in each workbook? If so, I just want to make sure that the only thing that you want to do is to copy/paste the data from the form workbook to the master workbook and put the data from each form workbook on a new line in master workbook.
don (rep: 1482) Feb 9, '18 at 1:38 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login