Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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.

excel
posted by: EgyBlind on Mon Jan 22, 2018 at 8:08 am
Answer
Discuss

Discussion

This is a forum for teaching Excel. What do you wish to learn?
Variatus (rep: 4889) 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: 1989) 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