PDA

View Full Version : Combine multiple sheets from multiple workbooks to a single workbook of multiple work



Mamom
02-20-2016, 06:50 AM
Hi Everyone,


My requirement is,
I have multiple Excel Files (Mathe, Bio, Eng, ...) with multiple sheets (cover, group01, grou02, group3,...).

I want to create a master workbook (Master) with one sheet (Mathe, Bio, Eng, ...) for every workbook. In the master workbook.sheet(mathe) shall be the combined data from Workbokk(Mathe) and sheets (group()) and sheet cover or others.
From the group-sheets i need the name of the workbook, coloumn (A,b, C, E, H).

Hope you can help me.

Thanks


workbook(Mathe).sheet(group01)


Group_01
Klasse
Mathematik

Group
Gruppe_01_Mathe_WiSe1516





Kurztitel
Mathe

Kurztitel
Gruppe01


















Sum









9





ID
Dozent
Kurs

Hours
Date
Hour
exam


1
Sebastian
Algebra A

3


1


2
Sebastian
Algebra A

3


1


3
Ulrich
Geo A

3


1


4
Ulrich
Geo A




1


5









6











workbook(Mathe).sheet(group02)


Group_02
Klasse
Mathematik

Group
Gruppe_02_Mathe_WiSe1516





Kurztitel
Mathe

Kurztitel
Gruppe02


















Sum









10





ID
Dozent
Kurs

Hours
Date
Begin
exam


1

Algebra A

4

08:00
1


2
Sebastian
Algebra A

3

14:00
1


3
Ulrich
Geo A

3

14:00
1


4









5














workbook(Master).sheet(Mathe)


Klasse
Mathematik








Kurztitel
Mathe

Kurztitel
Gruppe02














Group_01
Gruppe_01_Mathe_WiSe1516










ID
Dozent
Kurs
hours
exam





1
Sebastian
Algebra A
3
1





2
Sebastian
Algebra A
3
1





3
Ulrich
GeoA
3
1





4
Ulrich
Geo A

1


























Group_02
Gruppe_02_Mathe_WiSe1516










ID
Dozent
Kurs
hours
exam





1
Sebastian
Algebra A
3
1





2
Sebastian
Algebra A
3
1

Bob Phillips
02-20-2016, 09:45 AM
Does your Excel support Power, it would be trivial with this.

Mamom
02-20-2016, 01:53 PM
Does your Excel support Power, it would be trivial with this.


Hallo xld,

what do you mean with excel power. I need a acro, which go thru every excel file in the folder and copy a range from some sheet (group()) and paste them in a new workbook in a new sheet for every source file.
thanks